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

See Chip's stuff at www.cpearson.com
He seems to be down at the moment!
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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

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


"Nadia" wrote:

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

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


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