AutoFilter Criteria VBA

E

EstherJ

My macro for filtering and copying data into seperate worksheets will only
work when each criteria is specified. I want it to work its way through the
list on the drop down as the master spreadhsheet regulary has more items
added to it.

Thank you,

Esther
 
T

Tom Ogilvy

You can get a list of unique elements by using the Advanced filter, checking
the uniques checkbox in the first dialog and copy the list of uniques to
another location on your worksheet. You can then work down this list,
setting the criteria in your autofilter. The list in the dropdown of the
autofilter is not directly accessible programmatically.
 
Top