Extract dat from multiple Excel Files and sheets within the selected files
$10-30 USD
Paid on delivery
I need to be able to dump multiple Excel files and then define a keyword that must be extracted from the files and sheets within the files with the click of a button.
If a specific keyword is defined then all the data in the cells from that line must be extracted, I then need to be able to save the extracted data in a Excel or .CSV file. I need this done ASAP
Project ID: #10238059
About the project
Awarded to:
Hey there.... We had a look at your 1 page pdf document and we can write a tool/macro to fetch the required data from all the folders and also display the statistics (as requested)...please reply.. thank you..
I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I More
20 freelancers are bidding on average $48 for this job
I ll code a VBA macro which will work as follow : 1. Select the folder from where we will get the xls files 2. Will open each file and for each file treat all the worksheets. 3. The rows with your keyword will be gener More
Hi, I have read your project description and I’m an expert on these jobs and willing to start it right now! I Look forward to hearing from you. Regards Maariyaa
Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi
i can extract data from multiple sheet into selected sheet , i have an experience lets discuss more thank you
I have the expertise in Excel and can do this task, quickly and accurately. Ready to start work now.
Hello, I can help you with your issue. I manage excel and vba programming. We can do a little program to do that, where you put your keyword in a textbox and after the excel program will search that word in all your More
I am a postgraduate in finance (MBA) with more than 5 years of experience having expertise in Excel. Currently working in an MNC Analytical company on a large financial model for a leading US bank. I can help you with More