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
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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