"autofilter"

  • Thread starter Thread starter Leo J Gilpin
  • Start date Start date
L

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
 
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
 
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.
 
Back
Top