Hi
have a look at
http://www.cpearson.com/excel/duplic...tractingCommon


--
Regards
Frank Kabel
Frankfurt, Germany

"merlin63 " schrieb im
Newsbeitrag ...
Greetings!

Maybe someone could help me out here. I'm looking for an easy way of
comparing two different sheets of data and recording their
differences.
For instance, I want to compare a list of item numbers and prices and
see exactly which prices have changed from one sheet to the next.
Here's an example:

Sheet 1 (Let's say that this is my current prices)

ITEM PRICE
ITEM1 2.00
ITEM2 7.70
ITEM3 4.00
ITEM4 5.10

Sheet 2 (These would be the new prices)

ITEM PRICE
ITEM5 9.50
ITEM3 4.50
ITEM1 1.75
ITEM2 6.80

Now, as you can see, both sheets do not contain the same information
and are out of order. Item4 is missing from Sheet 2 and Item5 is
missing from Sheet 1. These should be ignored. Also, it should not
matter where in either sheet the data is located. What should happen
is
that the following items and new prices should be copied to sheet 3:

ITEM1 1.75
ITEM2 6.80
ITEM3 4.50

I attempted to do this with VLOOKUP but couldn't figure out exactly
how
to do all of this. My assumption is that a macro would probably be an
easier way to do this. Any suggestions?

Thanks!!


---
Message posted from http://www.ExcelForum.com/