Link to home
Start Free TrialLog in
Avatar of pdvsa
pdvsaFlag for United States of America

asked on

Compare Excel docs

Experts,

does Excel have the option to compare docs much like Word does?
I am using 2007.

thank you.
ASKER CERTIFIED SOLUTION
Avatar of Anastasia D. Gavanas
Anastasia D. Gavanas
Flag of Greece image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pdvsa

ASKER

OK I see 2007 does not have this compare functionality but 2010 does.

The macro that compares 2 spreadsheets is most interesting to me.
I looked at the link and there is the macro but then something below it and wondering if you know what this is:  
 Sub TestCompareWorksheets()

I dont know much about code.
How would it know which files you want to compare?  Maybe you can read it easily and let me know.

thank you
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pdvsa

ASKER

OK thank you for the explanation.  I will test it out when I  get a second.