"autofilter"

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
 
A

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
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top