function to remove duplicates from different sheets

Hello everybody
Is there a UDF function that extract distinct values from different sheets..?
Say I have duplicate values in Range ("A1:A20") in two different sheets and I want to extract the distinct values from the two lists ..
Is there a function that can do that task?

I have this code that do that task of extracting unique lists from multi sheets..

Please Login or Register  to view this content.

But it extracts a blank cell which is considered as a unique value.. I want to get rid of that blank unique value

Please Login or Register  to view this content.

Great Great Thank you very much
Is there a function that I can use to do the same by selecting my ranges from different sheets?

Is there a function? or I have to use codes ?

Okay
As for this wonderful code
I want to specify two sheets only sheet named (Result1) and sheet named (Export1).. Can I edit the code to be able to deal these two sheets?

Please Login or Register  to view this content.

Hi YasserKhalil,
maybe so

Please Login or Register  to view this content.

Thank you very much for great help in this great forum