Excel 2010 Compare

[Kevin Briere]

Hello,


I know Excel 2013 has this function just automatically built to run a compare against another spreadsheet & I have 2013 at home, but my work using 2010. Is there any VBA script which allows me to compare 2 worksheets that essentially look the same & highlights the differences? Word 2010 has a similar kind of function.

 

[Luke M]

The macro given here works well.
http://www.exceltip.com/cells-range...-worksheets-using-vba-in-microsoft-excel.html

Linked site also shows how to call the macro for different sheets/books.