Compare two worksheet having same name ranges but with different number of rows

satmisha
satmisha used Ask the Experts™
on
Hi Team,

I need to compare two worksheet having same name ranges lets say
Worksheet 1 contains two name ranges NM1 and NM2 which consist of 10*10 matrix i.e. 10 rows and 10 columns
similarly Worksheet 2 consist of same two name ranges NM1 & NM2 which consist of 20*10 matrix i.e. 20 rows and 10 columns.
I need to compare and find out the differences.
I'll be happy to have free tool or code(VBA) to do this.
I am using excel 2010.

Hopefully looking forward to hearing from you.

Regards,
Satmisha
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Professor JMicrosoft Excel Expert
Top Expert 2014

Commented:
There is a free Excel Add-in for comparing sheets under GNU General Public License version

you can download from the web below.

http://sourceforge.net/projects/spreadshcompare/

more detail by developer http://www.thefoolonthehill.net/drupal/sites/default/files/WebFM/admin/help/Spreadsheet_Compare/Spreadsheet%20Compare%20Help.html?Introduction.html
Sivaraj EssakiLead – IT Infrastructures

Commented:
Did you try with Beyond Compare ?

Regards, Shiva
Professor JMicrosoft Excel Expert
Top Expert 2014

Commented:
Beyond Compare is not a free software.

i believe   the link above, i shared, will serve the purpose for free.
Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Sivaraj EssakiLead – IT Infrastructures

Commented:
@ Professor Jim Jam
 
Correct it is not free, If it is needed for short-term then he can give a trial run of it. may be that will be helpful.

Regards, Shiva

Author

Commented:
Thanks for your prompt reply.

I checked that but it is doing cell by cell comparison whereas I need to compare different ranges in two different sheets.

Looking forward more reply from experts.

Author

Commented:
Also just to update I do require not for short term. we might use it extensively though not regularly as we do get reports fortnightly that we need to compare.

We do get worksheets with lot of name ranges inside that we need to compare either any data inside is deleted/modified/added.

Hopefully looking forward to hearing from you.
Professor JMicrosoft Excel Expert
Top Expert 2014

Commented:
in this case, i am affraid that free add-in would not work for you.

i am referring you to the Spreadsheet Advantage add-in and it is not a free add-in.
however, it gives 30 days free trial period and you can see if it serves the porpose of what you aim for.  if it works for you then perhaps you might want to purchase license from the same website below.

it can do a camparison not at the cell level, but in the inside cell input. I have used the trial version, but since it was 399USD but bit expensive for me :) i did not purchase the license, becuase i could use the free add-in , becuase i do not need deep analysis for worksheets.

http://www.spreadsheetadvantage.com/

Author

Commented:
I am OK with the paid version of the tool provided it serves the purpose. As discussed I need to compare worksheet with named ranges inside. In the meanwhile let me see the trial version suggested by you.
Microsoft Excel Expert
Top Expert 2014
Commented:
Good.  in that all of the below websites have trial versions of Excel Compare. you can give them a try and choose the best after testing among them to purchase a license.

http://www.synkronizer.com/

http://www.xlcompare.com/wct.asp     

http://www.florencesoft.com/compare-excel-workbooks-differences.html 

http://www.office-excel.com/excel-addins/compare-spreadsheets/?dstr

http://www.formulasoft.com/excel-compare.html

http://www.auditorsassistant.com/
Sivaraj EssakiLead – IT Infrastructures

Commented:
@ satmisha

Please give a try on this before go for purchasing stuffs

Excel Compare 3.0.2 For Free

Regards, Shiva

Author

Commented:
Thanks experts for providing so many solutions.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial