Extract dat from multiple Excel Files and sheets within the selected files

Completed Posted Apr 16, 2016 Paid on delivery
Completed 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

Excel Microsoft Access Microsoft Office

Project ID: #10238059

About the project

20 proposals Remote project Active 7 years ago

Awarded to:

expertatwork

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

$29 USD in 1 day
(137 Reviews)
5.7
prabakarm23

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

$35 USD in 1 day
(33 Reviews)
4.2

20 freelancers are bidding on average $48 for this job

bouslimi1979

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

$67 USD in 2 days
(114 Reviews)
6.5
Maariyaa

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

$100 USD in 2 days
(180 Reviews)
6.5
mantislin

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

$120 USD in 3 days
(58 Reviews)
6.1
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

$100 USD in 6 days
(94 Reviews)
6.1
mehedi276

"Rate and duration will be fixed on discussion" Dear Hiring Manager, I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have already completed se More

$23 USD in 1 day
(87 Reviews)
5.9
kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 70 projects, almost 65+ are complex VB/VBA/.Net/Webscrapping projects, hence i ca More

$74 USD in 1 day
(64 Reviews)
5.7
zu02

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Acc More

$111 USD in 1 day
(12 Reviews)
5.2
sknadeem123

i can extract data from multiple sheet into selected sheet , i have an experience lets discuss more thank you

$25 USD in 1 day
(24 Reviews)
4.9
surekash7096

I have the expertise in Excel and can do this task, quickly and accurately. Ready to start work now.

$35 USD in 1 day
(40 Reviews)
4.7
beltran0404

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

$30 USD in 1 day
(12 Reviews)
2.8
sharudl1991

I have done this kind of work and have 6 years experience in VBA..

$20 USD in 0 days
(5 Reviews)
2.2
crypthne

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ More

$30 USD in 3 days
(4 Reviews)
2.3
bhupendrayadav

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

$18 USD in 1 day
(5 Reviews)
2.0
sn33zy90

Hi, I should be able to write a Java program (runs on Windows or Mac) that you can load multiple excel files into the program, type what you want to search for, point the program to where you want to save the result More

$20 USD in 1 day
(2 Reviews)
1.2
anunair23

I am an experienced data entry, processing and mining specialist with excellent knowledge in analyzing, transforming and presenting large volumes of data. I possess advanced knowledge of programming/scripting languages More

$35 USD in 2 days
(0 Reviews)
0.0