SQL and Excel data cleaning expert

$30-250 AUD

In Progress

Posted

over 6 years ago

$30-250 AUD

Paid on delivery

Aim: Create Excel Control worksheets that runs Macro to perform the following: 1 Extract two data file(.xls) from known location and remove unused column + N/A (300K rows) The file is very large and therefore need to be efficient and effective. 2. Export data to SQL (create 2 new table- [login to view URL], xx2 ) 3. Join/ map the two SQL table to a "product list" (if the mapping doesnt exist- create error message and a log of what is missing) 4. SQL to group/ sum criteria (this will be indicated in the "control worksheet") 5. Export the data out in Excel table and saved in indicated location

Project ID: 16113280

About the project

6 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

6 freelancers are bidding on average $144 AUD for this job

@polarjin2017

Hello? How are you? I have good skills in excel and vba, vb. So i can help you then. i will never disappoint you. Hope to see you . Thanks.

$155 AUD in 3 days

4.7

(46 reviews)

5.8

@awaisjahangir25

Hi, I’ve good working experience of MS Excel and VBA programming. I’ve done several project relating this and you can review my profile as well. Kindly text me if you are interested in working with me. Thanks

$100 AUD in 1 day