Compare two worksheets using VBA in Microsoft Excel

When shared workbooks fail....

and you need to merge the two different copies (if the automatic merge won't work) you can use the VBA code at this site to get the differences between two worksheets and then manually (or write some more VBA code) merge the changes back into the original.

[Link]