Is there a faster way to do many to many matching of data in 2 worksheets than using two loops like ....
For r = 2 to r2
For rr = 2 to rr2
...
Next rr
Next r
Gets quite slow when worksheets have many thousands rows to compare. Would like to avoid using Access database if possible. Any ideas?
For r = 2 to r2
For rr = 2 to rr2
...
Next rr
Next r
Gets quite slow when worksheets have many thousands rows to compare. Would like to avoid using Access database if possible. Any ideas?