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

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

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