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