Filter, sort, filter and then display

[Guest]

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 shee
Those values should also be unique so if there are duplicate entries, the duplicate is discarded. How can I do that in VBA

 

[arno]

Hi Andrew,

just one thought: A sorted list is always sorted no matter if it is filtered
or not. Turn screenupdating off, sort your list according to A *and* B,
filter, do whatever you like.

arno

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?

 

[Tom Ogilvy]

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

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?