Comparing two workbooks - Excel 2010 - not using Add-ins
 

Hi All

I'm working in an office environment that does not allow add-ins or third party products. Just wondering if there is a way in Excel 2010 to compare two workbooks other than writing code to loop through each of the sheets and compare each populated cell in each sheet with the other (sheets will have the same name)?

Advice please.

Cheers
JulieD

Comparing two workbooks - Excel 2010 - not using Add-ins
 

Julie,

You may be able to accomplish this using Compare and Merge (assuming that your workbooks are shared). See these articles:

http://office.microsoft.com/en-us/ex...010177169.aspx

http://www.gcflearnfree.org/excel2010/extra/63

Comparing two workbooks - Excel 2010 - not using Add-ins
 

Hi Ben

Thanks for that. Unfortunately not 'shared'. I have found a website where you can do it (obviously not for 'sensitive' data) http://www.xlcomparator.net/ so I might see if that will work.

Cheers
Julie