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.