Closed

Automatically Update One Excel File by Comparing to Other 5

This project was awarded to imudita for $30 USD.

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

I need to automatically update data of one Excel file by comparing to data of other 5 Excel files. For an example, file#1 contains data for product id and attribute id, file#2 contains data for product id, color and size, and file#3 contains data for attribute id of each color and size. So, we compare file#2 and file#3 to convert the color and size to attribute id in file#2 and then compare to file#1 to add any new product id and attribute id.

In the actual Excel files, each file has no more than 5 columns of data, and I already know how the data should be compared and moved. It takes about 7 comparisons to complete the update.

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