Excel Macro developer

$14-30 NZD

В роботі

Опублікований

over 5 years ago

$14-30 NZD

Оплачується при отриманні

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

ID проекту: 17937313

Про проект

4 пропозицій(-ї)

Дистанційний проект

Активність 6 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

4 фрілансерів(-и) готові виконати цю роботу у середньому за $23 NZD

@rohitagarberg

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

$30 NZD за 1 день

5,0

(571 відгуки(-ів))

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 за 1 день

4,8

(148 відгуки(-ів))

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 за 0 день