D Darryll Oct 9, 2003 #1 I have 2 worksheets that should be identical. One I know has been changed. Is there any way to compare the 2 to track changes.
I have 2 worksheets that should be identical. One I know has been changed. Is there any way to compare the 2 to track changes.
A Andy B Oct 9, 2003 #2 Darryll One way is to use a third sheet. In A1 type =Sheet1A1=Sheet2A1 This will return TRUE or FALSE. Fill this across and down as many as you need Andy.
Darryll One way is to use a third sheet. In A1 type =Sheet1A1=Sheet2A1 This will return TRUE or FALSE. Fill this across and down as many as you need Andy.
D darryll Oct 9, 2003 #3 Thanks for your help Andy. All seems ok. -----Original Message----- Darryll One way is to use a third sheet. In A1 type =Sheet1A1=Sheet2A1 This will return TRUE or FALSE. Fill this across and down as many as you need Andy. . Click to expand...
Thanks for your help Andy. All seems ok. -----Original Message----- Darryll One way is to use a third sheet. In A1 type =Sheet1A1=Sheet2A1 This will return TRUE or FALSE. Fill this across and down as many as you need Andy. . Click to expand...
P pfsardella Oct 9, 2003 #4 Two AddIns that provide this functionality : http://www.cpearson.com/excel/download.htm http://www.rb-ad.dircon.co.uk/rob/excelvba/utils/comparesheets.htm HTH Paul
Two AddIns that provide this functionality : http://www.cpearson.com/excel/download.htm http://www.rb-ad.dircon.co.uk/rob/excelvba/utils/comparesheets.htm HTH Paul
