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.
35 freelancers are bidding on average $76 for this job
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...
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.
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
[url removed, login to view] the keywords are exact spelling? because with exact spelling, the vba might be less complicated and can be done [url removed, login to view] everything is possible with vba.i can start right now and can deliver in a day.i am prof More
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