I have two lists of products that are different for code and price. I have to compare them and get a third list that as the list 1, but without the codes that we are on the list 2.
Then compare two excel sheets (1 of 4 columns SKU, DESCRIPTION, Price1, ID and 1 in 3 columns SKU, DESCRIPTION Rate2) and create a third sheet that is the union of the previous two.
The third sheet must:
- Have 4 columns (SKU, DESCRIPTION, Price1, Rate2, ID)
- If some SKUs are not on the list 1 list 2 leave all the other fields blank so that I can see which SKU is not in the list 1 list 2
lines should not mix but each SKU, DESCRIPTION PRICE ID and must bind to each other (the ID is linked to and SKU DESCRIPTION and PRICE)
tables have about 8000 lines one o'clock
fornisto the two lists. In response I would like an excel file that I can use in the future.