Hi all,

My supplier has a new product file that has new products and has closed out others. I need to:

1) Know which products have been added to the new file which are not in my current inventory file
2) Know what products have been deleted from the new inventory file (that exist in my old file)

What is the best way to do this?


PS Here is the new file:

http://utmdistributing.com/Pet_Store...preadsheet.xls

The old file matches the data format. Column A (Item ID) is a reliable way to match the items together.