Closed

Need macro created in excel to merge data between excel file

This project was awarded to microk for $30 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
$30 - $250 USD
Total Bids
3
Project Description

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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online