M
merlin63
Greetings!
Maybe someone could help me out here. I'm looking for an easy way o
comparing two different sheets of data and recording their differences
For instance, I want to compare a list of item numbers and prices an
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 informatio
and are out of order. Item4 is missing from Sheet 2 and Item5 i
missing from Sheet 1. These should be ignored. Also, it should no
matter where in either sheet the data is located. What should happen i
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 ho
to do all of this. My assumption is that a macro would probably be a
easier way to do this. Any suggestions?
Thanks!
Maybe someone could help me out here. I'm looking for an easy way o
comparing two different sheets of data and recording their differences
For instance, I want to compare a list of item numbers and prices an
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 informatio
and are out of order. Item4 is missing from Sheet 2 and Item5 i
missing from Sheet 1. These should be ignored. Also, it should no
matter where in either sheet the data is located. What should happen i
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 ho
to do all of this. My assumption is that a macro would probably be a
easier way to do this. Any suggestions?
Thanks!