Duplicate Problem

I don't know how to explain this very well so I'll try to be as detailed as I possibly can.

Every 2-4 days I receive a new spreadsheet with items and prices. What I need to be able to do is take a look at the new spreadsheet and compare the records from the older spreadsheet to find out which items have a new price to them. The item names have 3 specific fields associated with them to determine their uniqueness.

Name - Set - Rarity - Quantity - Price

What's the easiest way for me to do this?

OK I have a blank spreadsheet. I posted old list in Sheet1. I posted new sheet in Sheet2.

I read the thing about vlookup! but I'm not sure if that's what I'm needing.

What I need to have happen is on Sheet3 there be a list of items that matched the three validating (Name - Set - Rarity) fields to verify that it's the same product and tell me, again on sheet three, that a price on Sheet2 is different than it is on Sheet1.

Here's an example:

Sheet1
Apple - Fruit - None - 50 - $2.49
Tomato - Fruit - None - 24 - $1.39
Orange - Fruit - Sparse - 8 - $0.48
Tomato - Vegetable - None - 38 - $1.09
Celery - Vegetable - Sparse - 5 - $1.89


Sheet2
Apple - Fruit - None - 50 - $2.49
Tomato - Fruit - None - 21 - $1.29
Orange - Fruit - Sparse - 8 - $0.57
Tomato - Vegetable - None - 38 - $1.09
Celery - Vegetable - Sparse - 5 - $1.49


Sheet3
Tomato - Fruit - None - 21 - $1.29
Orange - Fruit - Sparse - 8 - $0.57
Celery - Vegetable - Sparse - 5 - $1.49


Note I'm not looking at all 5 products on Sheet3. They're just the items that changed prices. It's Sheet2 that has the most current price.

Does this make since?

Here is the XLSX sheet. I left some notes on the last sheet. I hope it makes since. I don't know of any other way to explain it.

Thank you very much for all of your help!

Sorry, I'm using Excel 2007. I've saved it using the older version of Excel.

Try this version.

It looked like it worked when I put all 7000+ records in it but it only showed up 2 results. I know there are more than that.

Is it specific to how I sort it? I sort by Set - Rarity - Name. I don't know if that makes a difference or not.

It's exactly what I'm looking for though! Wow!

The new sheet works for about 500 records. It starts to work just fine then dies. Thinking it was a compatibility problem with your Excel and my 2007 I installed Excel 2003. Same result. It's pulling the differences nicely as long as I keep it under 500 though. Don't know if that helps out at all.

Do I need to do the same on the New Price List as well?

Just so you know it ran for about 5 minutes and it died.

*revised*

I only see Range("A1:A" & i + 250) in here twice. Where's the other reference?