If you didn't insert or delete any columns or rows, you can use an addin
developed by Myrna Larson and Bill Manville.
http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla
Remember that this does a cell-by-cell comparison. A1 compares to A1, x99 to
x99, etc.
Lisa wrote:
I have two excel spreadsheets... I had to make corrections and return for
updates to a vendor.. so I kept copy of original and made corrections on a
copy. I should have tracked my changes but didn't... I only want to return
the records that have changes made to them and I would like for the changes
to be highlighted marked so for easier viewing and entry on the other
end.... any suggestion
LIsa C
--
Dave Peterson