Access Merge data from several excel worksheets

$10-30 USD

Completed

Posted

almost 6 years ago

$10-30 USD

Paid on delivery

Project involves creating Excel VBA script or MS Access DB to merge data from multiple excel worksheets to create single excel spreadsheet/report. Step-1: Data from single column worksheets: Eyx, Eyx-Per, Nda, Oop, Lab, lew, Fas1, FasX, Ver and Eau is merged into CONSOL_LIST. Refer to Step-1 [login to view URL] Step-2: Data in Columns L thru AZ on CONSOL_LIST worksheet is populated from another excel workbook (Master Data) based on the value match in column A (IDS) on both workbooks. Refer to Step-3 [login to view URL] Step-3: The last step would be to lookup SURVEY worksheet, match on IDS and then populate SURVEY column (AM) with YES/NO. Refer to Step-3 [login to view URL], this is the final report format. I'm looking for someone to work on the project immediately with a quick delivery of 1 day max. Please bid only if you meet the criteria.

Visual Basic for Apps

Project ID: 16912223

About the project

8 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@dionisiotumbaga

Hi, I am interested in this project. Files will be imported to MS Access Tables, data to be processed and queries will be made to generate the required information. Output will then be exported to excel with all the data as indicated in the Project Specification. If work is awarded and files are received, work will be done and completed in less than a day. Regards.

$30 USD in 1 day

0.0

(0 reviews)

0.0

8 freelancers are bidding on average $36 USD for this job

@avinav606lx

Hello there, I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project , timeline and budget. Thanks A

$66 USD in 1 day

4.9

(176 reviews)

6.6

@Orientwork

Hello sir ! how are you ?? sir i can do your task as per your requirements e.g Access Merge data from several excel worksheets. please talk to me , regards

$30 USD in 2 days

4.8

(53 reviews)

4.8

@surekash7096

I have the expertise in Excel VBA and the experience in doing similar tasks in Excel. Ready to start work immediately.

$30 USD in 1 day

4.6

(70 reviews)

5.2

@huongth

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now

$30 USD in 3 days

4.9

(19 reviews)

3.6

@arslantahir87

expert candidate in excel and can complete with quality

$40 USD in 3 days

4.1

(13 reviews)

3.8

@nguyenban88

Hello i have read your request and would like to cooperate for you on the job, please contact me, i will do my best, thank you Access Merge data from several excel worksheets

$30 USD in 1 day