Excel Macro developer

进行中 已发布的 5 年前 货到付款
进行中 货到付款

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.

数据处理 Excel 软件构架 Visual Basic Visual Basic的应用程式

项目ID: #17937313

关于项目

5个方案 远程项目 活跃的5 年前

有5名威客正在参与此工作的竞标,均价$22/小时

rohitagarberg

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

$30NZD 在1天里
(508条评论)
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 更多

$15NZD 在1天里
(108条评论)
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 更多

$30 NZD 在0天内
(56条评论)
5.0
maguirrer

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

$16NZD 在1天里
(37条评论)
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 更多

$20NZD 在1天里
(10条评论)
3.4