Excel Macro developer -- 2

$15 NZD / hour

Cancelled

Posted

over 5 years ago

$15 NZD / hour

I am looking for an excel macro that will help me fill in csv files from 1 datasource/master csv file. The macro must find and match the appropriate part numbers from the datasource and input csv file and then add in the inventory number to the appropriate column. I have included the master inventory file, the output file sample (how it should look) and 3 other input files (millercat, ap, magnaflow). The input files all contain different part numbers from each other. If the program cannot match the input file's part number with the master file, then the result should be "0" zero on the final output. All input files will look similar. 3 columns: 1st column is the part number (that is used to match with the master file), 2nd column is the inventory number (derived from the master file), and the 3rd column is left alone. Please let me know if you can help. My budget was fixed at around $15. Thanks.

Data Entry

Data Processing

Excel

Software Architecture

Visual Basic

Project ID: 17937330

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 $16 NZD/hour for this job

@dgled

Hi, I have considerable experience working with Excel, and external databases (CSV as well) I consider myself a guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application (including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts).

$16 NZD in 40 days

4.9

(60 reviews)

6.7

@rIbrarahmed

Hi, I am very good in accounting and finance having 6 years of working experience in a multinational organization. Apart from that we have a team of skilled CA, ACCA, MBA's People and all are well experienced. we done this type of work on regular basis. I feel very fit for this project. For further you can visit my profile. Please contact with me. Thanks

$16 NZD in 40 days

4.8

(16 reviews)

4.1

@nishantha041

Dear Sir, I can help you for this project. I have developed many excel vba applications to achieve similar kind of purpose. I'll assure to provide ongoing support if required. kindly contact me. thank you

$15 NZD in 40 days

5.0

(4 reviews)

2.9

@qinchetan

Hi, In the input file you have shared column 2 is zero. ------------------------------------------- I am a lazy person so I started automating my work and became an expert in it. I have handled huge data and processed them with my automation skills. I have 9 years of experience in the Excel sheets and macro. Handled huge data in office. Completed many automation projects.

$15 NZD in 4 days