Comparing Worksheets

D

Darryll

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

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

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...
 
Top