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
Project Budget$30 - $250 USD
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online