sedang Berlangsung

Excel Row Selector Tool

We need an Excel macro which does the following: we have many spreadsheets, as many as 100, with lists of names, work titles, work department and email. The macro needs to find certain keywords in one of two columns (it must search both columns) and then select the complete record and export it to a separate spreadsheet. We need to be able to find a range of keywords. For example we might say, find all records with any of the following words in the specified columns: biology, medicine, pediatrics, psychiatry, healthcare, etc. etc. We also want an exclusion feature if possible. For example, we would like to say, find records with any of the keywords listed but exclude records with the following terms: part-time, consultant, adjunct, etc etc. Finally, we want the macro to search one spreadsheet after another and so we need some form of panel to specify which spreadsheets to search. All of the spreadsheets can be in one directory if this helps. Most single spreadsheets are a few thousand records but some are as large as 10,000.

Keahlian Pengumpulan Data, Excel

Lihat lebih lanjut: orgnize column row excel, macro row excel, next row excel, foreach row excel, experienced using excel words

Tentang Pemberi kerja:
( 73 ulasan ) New York, United States

ID Proyek: #11716883

Diberikan kepada:

vkalach

Hello. I have extensive experience working with excel vba WINDOWS. willing to do the work for you and in time. I am also willing to regularly perform your job. Describe in detail what you need. with respect Lagi

$60 USD dalam 3 hari
(11 Ulasan)
3.9

36 freelancer menawar pada rata-rata $75 untuk pekerjaan ini

jaylancer43

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among Lagi

$90 USD dalam 2 hari
(478 Ulasan)
8.0
$98 USD dalam 1 hari
(249 Ulasan)
7.6
someka

Hi there. I can write the macro you need. And yes, all files in the same directory will help a lot. The number of records don't matter much. Just contact me to discuss further. Thanks...

$94 USD dalam 2 hari
(131 Ulasan)
7.0
dpune

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 280 projects. Please look at the feedback left by my employers to know more about my work. Wai Lagi

$90 USD dalam 3 hari
(115 Ulasan)
6.2
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your pr Lagi

$90 USD dalam 3 hari
(106 Ulasan)
6.3
katilinas

Hello. 35 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!

$77 USD dalam 1 hari
(92 Ulasan)
5.9
macroPOL

Hello, I am Excel and VBA expert. I can complete this project. Please note that I have 100% completion rate and 5-star feedback on 50 projects.

$88 USD dalam 3 hari
(61 Ulasan)
5.6
nagybatonyi

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macr Lagi

$53 USD dalam 1 hari
(61 Ulasan)
5.7
asifdwan

Hi I'll do it, Please award me the job and I'm ready to start it right now. I look forward to hearing from you. Regards

$166 USD dalam 3 hari
(102 Ulasan)
5.8
MoohHHooM

Hi, i can do this for you earthier using VBA macro or separate application in VB.net (which i recommend as its much faster) so let me know more about your requirements.

$80 USD dalam 1 hari
(21 Ulasan)
5.1
mwarrenschultz

Hello! I am a professional programmer with many years of experience using Python. I have read your project description, and I can create the Excel search macro you require. To do so, I will use Python 3.5, which has ve Lagi

$100 USD dalam 1 hari
(18 Ulasan)
5.3
poduzov

Hi I'm an Excel expert with years of experience - VBA programming, data analysis, pivot tables, lookup, formulas, etc. Please provide the Excel files. Best regards, Denis Poduzov

$100 USD dalam 1 hari
(19 Ulasan)
4.7
$120 USD dalam 3 hari
(19 Ulasan)
4.7
nwss1986

hi.is the keywords are exact spelling? because with exact spelling, the vba might be less complicated and can be done quickly.but everything is possible with vba.i can start right now and can deliver in a day.i am prof Lagi

$55 USD dalam 1 hari
(40 Ulasan)
4.5
Taisho

Greetings, I can complete the project using VBA macros, storing matching rows in arrays, for a fast performance - what is important with so large amount of sheets. Exclusion will be supported. Finding method will Lagi

$68 USD dalam 3 hari
(37 Ulasan)
4.3
Mufaddalsaifee

Hi There, i have 6+ years of experience in excel and VBA, i can help u in this project. i have created many end to end applications in excel. kindly message me and provide me opportunity to work with you. Thanks

$55 USD dalam 2 hari
(26 Ulasan)
4.5
laurajiannaras

Hello, I have more than ten years experience working full-time with Excel, including extensive development of complex Excel/VBA macro logic to automate manual tasks. I propose a solution to be a macro-enabled Exc Lagi

$90 USD dalam 5 hari
(6 Ulasan)
3.7
milanmartinjuk

Hi, Your project sounds very interesting and simple enough and I believe that I'll be able to perform the task perfectly. Considering the great amount of data, my suggestion is to convert every spreadsheet into one Lagi

$90 USD dalam 5 hari
(18 Ulasan)
3.3
oguzyilmaz

Hello, How are you? I'm experienced with excel and Macros. Please check my references and my profiel for more info. I have checked your requirements, and i can make you an interface for searching which will also Lagi

$55 USD dalam 3 hari
(3 Ulasan)
3.1
abhishekpaliwalj

The requirement stated is to get data from any of the sheet with 2 keywords search. Input :- 2 column name , 2 keywords Output:- all the data from various sheet. Or Input :- 2 keywords to be searched , Output :- Lagi

$75 USD dalam 7 hari
(2 Ulasan)
2.8