Compare 2 similar excel worksheets

[Nadia]

How do I compare 2 similar excel worksheets?
Both have identical rows and colums, the text may differ in text row, kindly
assist?

 

[Bernard Liengme]

See Chip's stuff at www.cpearson.com
He seems to be down at the moment!
best wishes

 

[CLR]

I use Jim Cone's fine commercial Add-in called XL Companion for this sort of
thing. It's available at

http://www.realezsites.com/bus/primitivesoftware/

.......works fine, lasts a long time.......

Vaya con Dios,
Chuck, CABGx3

 

[Bernie Deitrick]

Nadia,

Make a third worksheet, and in cell A1, use the formula

=Sheet1!A1=Sheet2!A1

and copy that formula for as large a range as is used on sheet1 and sheet2. Then find the FALSE
values and they will indicate which cells are different.

HTH,
Bernie
MS Excel MVP