Maybe someone can help with this.

I have data that I automatically download with Excel that contains
item numbers, price and quantities, among other things in other
columns. I have another spreadsheet that contains my current prices
and item numbers. The spreadsheet that I download contains many more
items than I currently have on my spreadsheet. If I had the new items
I downloaded located in Sheet 1 and my current items in Sheet 2, how
could I (with a macro) compare the two and display only the data that
has changed on a different sheet (ignoring all items that I currently
do not have on my spreadsheet)? Here's an example:

On my new spreadsheet (the one that is updated daily) an item is
listed with an item number "100" and a price of $25.
My current spreadsheet has item number "100" listed at a price of $17.
When I run the macro, I would like it to list (on another sheet) the
item number "100" and the new price of "$25"
All other data will be ignored if I do not have it listed on my
spreadsheet.

Can anyone help? If needed, I can list more details.

TIA!