Excel Macro developer

In Progress Posted 5 years ago Paid on delivery
In Progress Paid on delivery

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 around $15. Thanks.

Data Processing Excel Software Architecture Visual Basic Visual Basic for Apps

Project ID: #17937313

About the project

5 proposals Remote project Active 5 years ago

5 freelancers are bidding on average $22 for this job

rohitagarberg

Hi I have checked the csv and develop a macro for your desired output Regards

$30 NZD in 1 day
(508 Reviews)
6.9
vsprybhanu

Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I create a macro to accomplish this job. I have excellent knowledge and experience of Manipulating Data of Multipl More

$15 NZD in 1 day
(108 Reviews)
5.9
paulodayto08

Hi Good Day! I can help you to complete your Excel works in less than a day. I am a vba macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. I created different tem More

$30 NZD in 0 days
(56 Reviews)
5.0
maguirrer

Hello, I can help you with this project, please send me a message so I can start working on it inmediately.

$16 NZD in 1 day
(37 Reviews)
4.3
yyer

I have done many Excel automation tasks (VBA based) and see no difficulties in this one. In addition I have proper skills with Google sheets and scripting. I prefer to use direct script solutions without formulas in c More

$20 NZD in 1 day
(10 Reviews)
3.4