In Progress

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: orgnize column row excel, macro row excel, next row excel, foreach row excel, experienced using excel words

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

Project ID: #11716883

Awarded to:

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 More

$60 USD in 3 days
(11 Reviews)
3.9

36 freelancers are bidding on average $75 for this job

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 More

$90 USD in 2 days
(478 Reviews)
8.0
$98 USD in 1 day
(249 Reviews)
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 in 2 days
(131 Reviews)
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 More

$90 USD in 3 days
(115 Reviews)
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 More

$90 USD in 3 days
(106 Reviews)
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 in 1 day
(92 Reviews)
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 in 3 days
(61 Reviews)
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 More

$53 USD in 1 day
(61 Reviews)
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 in 3 days
(102 Reviews)
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 in 1 day
(21 Reviews)
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 More

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

$55 USD in 1 day
(40 Reviews)
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 More

$68 USD in 3 days
(37 Reviews)
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 in 2 days
(26 Reviews)
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 More

$90 USD in 5 days
(6 Reviews)
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 More

$90 USD in 5 days
(18 Reviews)
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 More

$55 USD in 3 days
(3 Reviews)
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 :- More

$75 USD in 7 days
(2 Reviews)
2.8