Excel Macro developer -- 2

$15 NZD / hour

Скасований

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

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

ID проекту: 17937330

Про проект

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

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

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

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

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

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

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

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

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

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

@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 за 40 дні(-в)

4,9

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

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 за 40 дні(-в)

4,8

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

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 за 40 дні(-в)

5,0

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

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 за 4 дні(-в)