Excel Macro developer -- 2
$15 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 fixed at around $15. Thanks.
项目ID: #17937330
关于项目
有6名威客正在参与此工作的竞标,均价$16/小时
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 don 更多
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