compare two worksheets (with different number of rows on each sheet) and to get the list of not matching rows

Vote count:

0

Below is my requirement

1.Two sheets are available , say Sh1, Sh2

2.Row count differs between both the sheets(row count may/may not be the same between them)

3.Used Column of the sheets varies for data considered for comparison But at any given point of time, both sheets will have same number of Used columns ( ideally speaking range is Dynamic for both sheets)

4.Now I need to perform comparison between them and find out the excess records in Sh1, Sh2 and save them in diff worksheets Sh3, Sh4 or so.

5.The comparison performed needs to be a Row level Comparison between Sh1 & Sh2 6.I prefer using Arrays (Loading the worksheets to Arrays) and perform comparison on it and return value - PERFORMANCE PLAYS A MAJOR ROLE SINCE THE DATA MAY BE OFF MILLIONS OF RECORDS

1. Is there a way to perform comparison of two Arrays whose size are non-identical ?


2. 
   

   Matched rows can be Ignored

   
   


3. 
   

   Is there a way to apply some Join() functions and read a complete row from Array1 and compare them with Array2 ?

   
   

Sorry If im violating the Forum rules by Any means !

I hope there is no Discussion on Comparing Two sheets with different Dynamic ranges to find the mismatches either here or anywhere

I mostly see ppl limiting the comparison to only one Column , or just for fixed ranges

My ULTIMATE AIM IS TO DO SOME VBA CODE WHICH OPERATES KIND OF "BEYOND COMPARE"(Well not exact behavior, read it a like)

asked 1 min ago

user3586153

1