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.

Skills: Data Mining, Excel

See more: converting word document table row excel, convert multiple column row excel, aspnet update specifc row excel file, convert word table single row excel, combining duplicate rows row excel, copy row excel file via vbscript, check row mkdir row excel, orgnize column row excel, copy row excel using vbscript, parse excel words commas, workload chart tool work load excel, third party tool oralce report excel, macro row excel, next row excel, foreach row excel, class row excel, experienced using excel words

About the Employer:
( 74 reviews ) New York, United States

Project ID: #11716883

Awarded to:


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 More

$60 USD in 3 days
(11 Reviews)

35 freelancers are bidding on average $76 for this job


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 More

$90 USD in 2 days
(483 Reviews)
$98 USD in 1 day
(249 Reviews)

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 in 2 days
(131 Reviews)

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 More

$90 USD in 3 days
(117 Reviews)

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 More

$90 USD in 3 days
(109 Reviews)

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 in 1 day
(92 Reviews)

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 in 3 days
(111 Reviews)

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 in 3 days
(61 Reviews)

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 More

$53 USD in 1 day
(61 Reviews)

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

$80 USD in 1 day
(24 Reviews)

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 More

$100 USD in 1 day
(18 Reviews)

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 in 1 day
(19 Reviews)
$120 USD in 3 days
(20 Reviews)

[login to view URL] the keywords are exact spelling? because with exact spelling, the vba might be less complicated and can be done [login to view URL] everything is possible with vba.i can start right now and can deliver in a day.i am prof More

$55 USD in 1 day
(40 Reviews)

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 More

$68 USD in 3 days
(37 Reviews)

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 in 2 days
(26 Reviews)

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 More

$90 USD in 5 days
(6 Reviews)

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 More

$90 USD in 5 days
(18 Reviews)

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 More

$55 USD in 3 days
(3 Reviews)

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 :- More

$75 USD in 7 days
(2 Reviews)