Linking /Copying Autofilter Arrows

T

TONYC

I have a created a spreasheet with autofilters in a worksheet name
"List", and created macros on a main menu worksheet named "Search".
am wanting to either link or copy the dropdown arrows in the filte
mode from the "List" worksheet, on to the "Search" worksheet, lisitn
the selection criteria.

Is this possible
 
D

Debra Dalgleish

You can't link to the AutoFilter arrows.

You could use an Advanced Filter to create a list of the unique items in
a column. There are instructions here:

http://www.contextures.com/xladvfilter01.html

Then, create a data validation list, using the filtered list as the
source. There are instructions here:

http://www.contextures.com/xlDataVal01.html

The macro could use the contents of the data validation cells as
criteria for the AutoFilter on the List sheet.
 
Top