You could do this with 3 worksheets, two of which are the
ones you want to compare.
In cell A1 of the comparison worksheet, type an '=' sign,
then select cell A1 on one of the other worksheets. Then
type another '=' sign and select cell A1 on the remaining
worksheet and press <Enter>.
This now tells you if cell A1 on the two worksheets you
want to compare have the same values, by displaying 'TRUE'
or 'FALSE'.
Edit the formula in your comparison worksheet by removing
any '$' symbols, then copy cell A1 down & across as many
cells as you need to compare from the others. Now you'll
have a display showing 'TRUE' or 'FALSE' throughout.
If you're only comparing numeric values, change the
second '=' in the above formula to a '-', so that you can
see the amount of any differences.
Cheers
