Hi all,
I would like to know whether is there any way to compare data from 2 different sheets using advanced filters. sheet1 consists of mastercopy data while sheet2 consists of some data populated from sheet1.
my aim:
compare sheet1 and sheet2, then copy the unique values into sheet3
(so data in sheet2+ data in sheet3 = data in sheet 1).
i have tried using looping to compare, and it took ages( i stopped the macro halfway after 10mins because it took too long) to go through 10k rows of data in sheet1.
i have also tried copying both sheet1 and sheet2 into sheet3, then delete those rows that are repeated. it takes 2-5mins to go through 10k rows of data in sheet1, and i am expecting around 60k rows of data to compare.
currently i am trying to use advanced filter to come out with a faster solution.however, the problem i am facing now is that advanced filter seems to be able to work only for 1 region of data in 1 sheet.
does any1 have any idea or better solution?
i am open to any suggestions.
thanks
Bookmarks