Advanced Filter

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

i have attached an example of my project.it compares column a,b,c of sheet "raw_data" and "manual selection" and then copy the unique data into "hidden". please take a look and give some advice for improving the project. thanks

ps: it is uncompleted and has plenty of room for improvements.

@pr4t3ek : thanks. i shall try it out and let you know later.

@romperstomper : i have 3 columns of data to check.currently, my macro checks the value of individual cells in the region for duplicates. i am wondering if there is any possible ways to check the data row by row instead of cell by cell.

any advice?

oh my god....i am so sorry about that. i had to do something else right after i replied in the thread. i had totally forgotten about the file contributed by pr4t3ek. i promise i will go through both files the moment i reach office tomorrow morning. once again, i am terribly sorry for forgetting about the file and thanks for the help from both of you

@pr4t3ek : i am sorry that i do not understand how your attached file work.what is "sql queries"?

@romperstomper: the column a in sheet"raw_data" always shows true no matter if there is any duplicates in sheet"manual selection". but thanks. i have gotten an inspiration and trying out the "countif" function for my macros.

is there any help?

alright. thank you for your effort and time spent