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

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

ID Proyek: #11716883

Diberikan kepada:


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 Lebih banyak

$60 USD dalam 3 hari
(11 Ulasan)

35 freelancer menawar dengan rata-rata $76 untuk pekerjaan ini


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 Lebih banyak

$90 USD dalam 2 hari
(483 Ulasan)
$98 USD dalam 1 hari
(249 Ulasan)

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)

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 Lebih banyak

$90 USD dalam 3 hari
(117 Ulasan)

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 Lebih banyak

$90 USD dalam 3 hari
(109 Ulasan)

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)

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
(111 Ulasan)

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)

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 Lebih banyak

$53 USD dalam 1 hari
(61 Ulasan)

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 dalam 1 hari
(24 Ulasan)

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 Lebih banyak

$100 USD dalam 1 hari
(18 Ulasan)

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)
$120 USD dalam 3 hari
(20 Ulasan)

[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 Lebih banyak

$55 USD dalam 1 hari
(40 Ulasan)

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 Lebih banyak

$68 USD dalam 3 hari
(37 Ulasan)

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)

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 Lebih banyak

$90 USD dalam 5 hari
(6 Ulasan)

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 Lebih banyak

$90 USD dalam 5 hari
(18 Ulasan)

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 Lebih banyak

$55 USD dalam 3 hari
(3 Ulasan)

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 :- Lebih banyak

$75 USD dalam 7 hari
(2 Ulasan)