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

[julied]

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 andcompare each populated cell in each sheet with the other (sheets will havethe same name)?

Advice please.

Cheers
JulieD

 

[Ben McClave]

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/excel-help/merge-copies-of-a-shared-workbook-HP010177169.aspx

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

 

[julied]

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