"autofilter"

[Leo J Gilpin]

Hi,

I would like to know if there is any way I can use auto
filter more than one time on a work sheet? Example, Row
1/column A. and then Row 20 column A. I would like to
use the autofilter in several rows on the work sheet
without having to remove in from one row and then drop
down and reinstall it in another row. Please advise.

Leo J Gilpin

 

[Andy Brown]

Not AFAIK. You could use a macro -

Sub Filter()
Selection.AutoFilter
Selection.AutoFilter
End Sub

(1st one will turn it off where you were ; 2nd will turn it on where you
are) and assign it to a custom button.

HTH,
Andy

 

[Myrna Larson]

Sorry, but you can have only one set of drop-down arrows on a sheet.

 

[John Tjia]

You will have to set up multiple columns: Column A works on the rows
1-20 (in actuality it works for all the rows in the column, but you
only have the autofilter elements in rows 1-20), column B works for
rows 21-50, column C for 51-100, etc.