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

Completado Publicado Apr 16, 2016 Pagado a la entrega
Completado Pagado a la entrega

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

Nº del proyecto: #10238059

Sobre el proyecto

20 propuestas Proyecto remoto Activo May 7, 2016

Adjudicado a:

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 en 1 día
(137 comentarios)
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 Más

$35 USD en 1 día
(33 comentarios)
4.2

20 freelancers están ofertando un promedio de $48 por este trabajo

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 Más

$67 USD en 2 días
(114 comentarios)
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 en 2 días
(180 comentarios)
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 en 3 días
(58 comentarios)
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 Más

$100 USD en 6 días
(94 comentarios)
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 Más

$23 USD en 1 día
(87 comentarios)
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 Más

$74 USD en 1 día
(64 comentarios)
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 Más

$111 USD en 1 día
(12 comentarios)
5.2
sknadeem123

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

$25 USD en 1 día
(24 comentarios)
4.9
surekash7096

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

$35 USD en 1 día
(40 comentarios)
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 Más

$30 USD en 1 día
(12 comentarios)
2.8
sharudl1991

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

$20 USD en 0 días
(5 comentarios)
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 Más

$30 USD en 3 días
(4 comentarios)
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 Más

$18 USD en 1 día
(5 comentarios)
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 Más

$20 USD en 1 día
(2 comentarios)
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 Más

$35 USD en 2 días
(0 comentarios)
0.0