My situation:
I got a huge excel sheet from a manufacturer of products for my online shop. This format:
product ID | price | name | ...
Every week the manufacturer is sending me a updated list with new products. So I need to know which products are new in that list. So what I need is a code snippet, which does the following:
- I´m gonna insert the old product list in sheet1 (manually)
- I´m gonna insert the new product list in sheet2 (manually)
- Compare the product IDs of Sheet1 and Sheet2
- Insert the products (rows) from the new list (Sheet2) in Sheet3, which are not present in the old list (Sheet1)
So the result in Sheet3 would be all new products.
I hope you can push me in the right direction.
Regards
Best Answer
I think You might need something like this:
=VLOOKUP(Sheet1!A1:A100,Sheet2!A1:F100,6,FALSE)
source: https://stackoverflow.com/questions/15396677/excel-compare-two-cell-from-different-sheet-if-true-copy-value-from-other-cell
Of course You can also solve this, using VBA with buttons and all kind of fancy things.