Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check 3 cells, only one of the cells my be filled | Excel Worksheet Functions | |||
Need to add a check box a group of cells | Excel Discussion (Misc queries) | |||
How to check multiple cells | Excel Worksheet Functions | |||
check value into cells | Excel Discussion (Misc queries) | |||
How to check cells in a range for a value | Excel Programming |