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

Hi EstherJ

Try the last macro on this page
http://www.rondebruin.nl/copy5.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"EstherJ" wrote in message ...
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

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.

--
Regards,
Tom Ogilvy

"EstherJ" wrote in message
...
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