Remove duplicates and display only cell values which are equal or morethan today's date

Hi

I have a macro which removes duplicates (please see below)

Please Login or Register  to view this content.

However, after removing duplicates, macro to should identify and display only values(dates) which are equal or greater than today and sort the values(dates).
For more clarity please look at the below example.



Example.

Lets say, we have following values(dates) in Column-A
12/1/2015
12/5/2015
12/21/2015
12/23/2015
12/5/2015
12/3/2015
12/10/2015
12/1/2015
12/10/2015
12/6/2015

Say, today's date is 12/6/2015

after running the macro, the result should be displayed in B-Column like shown below
12/6/2015
12/10/2015
12/21/2015
12/23/2015


Any help is appreciated.

Originally Posted by JLGWhiz

See if this will work

Please Login or Register  to view this content.

Thank you JLGWhiz.

Originally Posted by Debraj Roy

you can try Advance filter too..

Attachment 437249

Thank you Roy

Originally Posted by Madhut

Thank you JLGWhiz.

You are welcome,
Regards, JLG