Maybe you could use a program written by Myrna Larson and Bill Manville.

You can find a copy on Chip Pearson's site:
http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla



Erin wrote:

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

--

Dave Peterson