Compare excel documents

[Joe1010]

MsWord has a build in option to compare and merge documents.
I’m trying to compare an excel documents. Is this possible? Does excel also have some kind of tolls for this?
Thanks

 

[yogia]

MsWord has a build in option to compare and merge documents.
I’m trying to compare an excel documents. Is this possible? Does excel also have some kind of tolls for this?

Hi Joe:

You could consider using Conditional Formatting ... highlighting the contents of those cells of one worksheet that are not the same as those of the cells of another worksheet.



Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com

 

[Joe1010]

How do I do this?

That’s also means that I need to copy all sheets from the main documents into the second. Correct?

 

[yogia]

How do I do this?

That’s also means that I need to copy all sheets from the main documents into the second. Correct?

Hi Joe1010:

One worksheet will have to be compared at a time -- the sheet you are comparing with does not have to be copied to the main document. You can assign a RangeName to all the cells of the sheet you are comparing with.

If this si something you want to pursue and if you need to discuss this futher please post back and if you like I can post an illustration for you.

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com

 

[Joe1010]

Will this also work if additional lines where added to one of the Excel files?

YES, I would like to compare it. And thanks for your help.

Can you please reply with the method how to compare it?

Is it possible to setup a macro to run the compare method for each sheet?
The sheet name will be the same in both documents.

Thanks again

 

[GlennUK]

The spreadsheet add-in UltraSleuth Gold has a Worksheet Compare option. But you have to pay for it. See here:

http://www.dslimited.biz/index.html

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.