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.
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.