Compare two worksheet having same name ranges but with different number of rows
Posted on 2014-03-03
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.