Compare Two Worksheets and Highlight Changes
 

I have a workbook where sheet 1 and sheet 2 have the same basic
information, but sheet 2 is the most up to date version. Is there
simple macro to compare the data in each sheet and highlight the cells
in sheet 2 that changed?

Thank you!


--
TEAM
------------------------------------------------------------------------
TEAM's Profile: http://www.excelforum.com/member.php...o&userid=22810
View this thread: http://www.excelforum.com/showthread...hreadid=539939

Compare Two Worksheets and Highlight Changes
 

Any ideas on this one? I really need some help. Is there a way to do
it using VLookup?


Thanks.


--
TEAM
------------------------------------------------------------------------
TEAM's Profile: http://www.excelforum.com/member.php...o&userid=22810
View this thread: http://www.excelforum.com/showthread...hreadid=539939

Compare Two Worksheets and Highlight Changes
 

Might this help?

http://www.ablebits.com/excel-find-r...anager-addins/

Raymond

"TEAM" wrote in message
...

Any ideas on this one? I really need some help. Is there a way to do
it using VLookup?


Thanks.


--
TEAM
------------------------------------------------------------------------
TEAM's Profile:
http://www.excelforum.com/member.php...o&userid=22810
View this thread: http://www.excelforum.com/showthread...hreadid=539939