Excel Macro developer

$14-30 NZD

In Progress

Posted

over 5 years ago

$14-30 NZD

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

4 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

4 freelancers are bidding on average $23 NZD for this job

@rohitagarberg

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

$30 NZD in 1 day

5.0

(571 reviews)

7.1

@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 Multiple Sheets. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra

$15 NZD in 1 day

4.8

(148 reviews)

6.2

@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 template and tools for financial reports. I am also a Project Management Analyst that focused in Financial and Metrics report and analyzation. Feel free to message me to discuss more about this project. Hope you will consider me to this project, I'll promise to give you the high quality of work. You can check my portfolio for some of my previous project in Ms Excel Macro Thank you!

$30 NZD in 0 day