Excel – Compare two sheets in Excel and extract the differences to other third sheet

microsoft excelmicrosoft-excel-2007microsoft-excel-2010vba

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.

Related Question