Need macro created in excel to merge data between excel file
$30-250 USD
Dalam Kemajuan
Disiarkan hampir 13 tahun yang lalu
$30-250 USD
Dibayar semasa penghantaran
I need a macro created in excel or a simple software developed that can merge data from 2 excel sheets based on criteria. I have a main excel file that has 3000 part numbers with titles, categories, and descriptions. I then have another excel file that has titles, descriptions, pricing, and part numbers. I want a macro created that will search the part number field of excel file 1 and copy corresponding titles, categories, and descriptions from excel 2 based on matching part number. I want someone that is experienced in this and possibly can create software that i can set criteria to output the file in a certain format. Should all be a CSV
When responding please indicated if you will create a macro for excel, or if you will develop a custom .net software.
Below is an example file. Typically the partnumber will not be in the same order and will be mixed up.
Very Good at Excel 2003-2010 and Excel VBA Macros. Please allow me to do it. Can build an Excel Macro that will import both the file to excel, lookup all the data you want and save the ouput to csv. Will ensure everything is as per your requirement.