In Progress

Need macro created in excel to merge data between excel file

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.

Skills: C# Programming, C++ Programming, Data Processing, Excel, Visual Basic

See more: set data, format pricing, custom number format in excel, excel macro merge excel file, merge macro excel, merge excel sheets, simple macro, pricing excel, need pricing, merge data, macro, macro excel, macro + excel, format excel, excel-to-csv, excel to, Excel to CSV, excel $2-30, data visual, data processing in excel, data merge, data 3000, copy excel, excel categories, csv merge

About the Employer:
( 29 reviews ) Philadelphia, United States

Project ID: #1115934

Awarded to:

microk

Let's start...

$30 USD in 1 day
(20 Reviews)
4.1

3 freelancers are bidding on average $30 for this job

dobreiiita

Ready to work. Check PM>

$30 USD in 1 day
(117 Reviews)
5.9
vgrichards

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 everyth More

$30 USD in 1 day
(19 Reviews)
3.7