Multi ranges to Auto filter in one worksheet

Closed
Issa - Feb 10, 2011 at 03:53 AM
 Issa - Feb 10, 2011 at 04:40 AM
Hello,
Is it possible in Excel 2003 to use Auto Filter more than once (twice) on ONE worksheet? I have a worksheet containing two ranges of information (A1:W100) and (A105:W400) and wish to AutoFilter each range separately, but to be on the same working sheet. I do not want to use seperate sheets. Is there any VBA code to use, please advice and Many Thanks.
Issa

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Feb 10, 2011 at 04:05 AM
as far as I know, answer is a NO

only way i can think of is by doing some creative thinking and use some temp cols etc, so that with one filter you can still filter both your ranges. Even that would depend what u want to do. it just might be impossible to do on one sheet
0
Thank a lot to your reply.
0