Avatar of pdvsa
pdvsa
Flag 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.
Microsoft Excel

Avatar of undefined
Last Comment
pdvsa

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Anastasia D. Gavanas

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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
byundt

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
pdvsa

ASKER
OK thank you for the explanation.  I will test it out when I  get a second.
Your help has saved me hundreds of hours of internet surfing.
fblack61