rageon75, here is a post by Gord Dibben on the subject and the addin is free

The add-in, Compare.xla written by Myrna Larson and Bill Manville, allows
you to compare the contents of two workbooks and highlight differences.


http://www.cpearson.com/excel/whatsnew.htm


Look for Compare.xla.


Download Compare.xla and add it with rest of your your add-ins.
On Tools Menu, select add-ins and check in (tick in)Compare Worksheets.
From tools menu then select Compare Sheets and follow instructions.

Gord Dibben Excel MVP - XL97 SR2 & XL2002



--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"rageon75" wrote in
message ...

Hello everybody! I need to know how to compare two worksheets. I do not
know anything about Excel. I need to know how to generate the
differences into a new worksheet. Any help would be appreciated. Thank
you.


--
rageon75
------------------------------------------------------------------------
rageon75's Profile:
http://www.excelforum.com/member.php...o&userid=31862
View this thread: http://www.excelforum.com/showthread...hreadid=515903