You are short on details but.............................
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 at 14-June-2000
Download Compare.ZIP, unzip 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
On Tue, 12 Aug 2008 06:58:01 -0700, Joanne
wrote:
is there a way to compare 2 workbooks automatically?