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.