Check Cells are EXACTLY the Same
 

Hi,

Is it possible to easily check all cells on Sheet2 are exactly the
same as on Sheet1? Note, I then have to repeat this check on sheet3,
sheet4...sheet8. I can't do a simple copy & paste special, because
there may be constants on the different sheets, or the formatting may
have been deliberately altered (so really I just want to highlight the
differences in the cells).

I want to check:

* formulas
* formatting (font style, font color, cell interior, conditional
formatting)
* borders
* protection
* comments

I'd like to think this is comprehensive (although worried I may've
missed something).

If there is no solution, I've already written the code, so please
don't trouble writing/posting any. I'm just hoping for a pointer, or
general advice, if there is a solution.

Many thanks in advance,
Chris Adams

Check Cells are EXACTLY the Same
 

Hi
you may have a look at

http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla (http://www.cpearson.com/Zips/Compare.ZIP)


--
Regards
Frank Kabel
Frankfurt, Germany


Chris Adams wrote:
Hi,

Is it possible to easily check all cells on Sheet2 are exactly the
same as on Sheet1? Note, I then have to repeat this check on sheet3,
sheet4...sheet8. I can't do a simple copy & paste special, because
there may be constants on the different sheets, or the formatting may
have been deliberately altered (so really I just want to highlight
the
differences in the cells).

I want to check:

* formulas
* formatting (font style, font color, cell interior, conditional
formatting)
* borders
* protection
* comments

I'd like to think this is comprehensive (although worried I may've
missed something).

If there is no solution, I've already written the code, so please
don't trouble writing/posting any. I'm just hoping for a pointer, or
general advice, if there is a solution.

Many thanks in advance,
Chris Adams

Check Cells are EXACTLY the Same
 

Many thanks for the pointer Frank.

"Frank Kabel" wrote in message ...
Hi
you may have a look at

http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla (http://www.cpearson.com/Zips/Compare.ZIP)


--
Regards
Frank Kabel
Frankfurt, Germany


Chris Adams wrote:
Hi,

Is it possible to easily check all cells on Sheet2 are exactly the
same as on Sheet1? Note, I then have to repeat this check on sheet3,
sheet4...sheet8. I can't do a simple copy & paste special, because
there may be constants on the different sheets, or the formatting may
have been deliberately altered (so really I just want to highlight
the
differences in the cells).

I want to check:

* formulas
* formatting (font style, font color, cell interior, conditional
formatting)
* borders
* protection
* comments

I'd like to think this is comprehensive (although worried I may've
missed something).

If there is no solution, I've already written the code, so please
don't trouble writing/posting any. I'm just hoping for a pointer, or
general advice, if there is a solution.

Many thanks in advance,
Chris Adams