Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Find Discrepancies between Worksheets
I have 2 worksheets that should be identical (merged cells, colors/borders,
number formats...), but when I try to paste values from one to the other, it kicks it out because merged cells are not identically sized. Obviously, there is some discrepancy in the thousands of cells of formatting. Is there a way to compare the 2 worksheets and come up with a list of what is different? It's a long story why I can't just overwrite the one, but please just trust that one sheet cannot be changed at all and the other is an output from a database that I do not have access to and so have to give the administrator a list of changes to be made. Thank you for any help! Erin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I Print the Results of a FIND ALL from multiple worksheets? | Excel Worksheet Functions | |||
Spawning worksheets and a summary per worksheet | Excel Discussion (Misc queries) | |||
getting a formula to find named worksheets in another? | Excel Worksheet Functions | |||
How do I compare 2 worksheets, 1 old, 1 updated to find difference | Excel Discussion (Misc queries) | |||
Protect/unprotect all worksheets | Excel Worksheet Functions |