this page on John Walkenbach's site can be adapted to what you want to do

http://j-walk.com/ss/excel/tips/tip47.htm

Just add a check for your filter condition. You don't actually have to
apply a filter.

Then write the contents of the collection to the cells in the destination
location rather than to a listbox as shown in the code.

--
Regards,
Tom Ogilvy

"Andrew" wrote in message
...
This is the scenario. I need to filter the worksheet data with a criteria
that is in Column A,
After that I need to sort the values in Column B in ascending order then
display those values in another sheet
Those values should also be unique so if there are duplicate entries, the
duplicate is discarded. How can I do that in VBA?