Autofilter problem

dg1069 · #1 (**permalink**) 09-15-10, 07:36

hi,

I am trying to get the filter data in sheet 2 based on filter criteria selected in sheet 1. i am able to do the same when one criteria is selected, but unable to extend the same for multiple selections. I am using Excel 2007. Following is my code:

Code:

With Worksheets("Sheet1")
    If .AutoFilterMode Then
        With .AutoFilter.Filters(1)
            If .On Then c1 = .Criteria1
        End With
   End If
    End With
    
    Sheets("Sheet2").Range("$A$2:$P$11").AutoFilter Field:=1, Criteria1:= _
        c1

Please help!!!

Colin Legg · #2 (**permalink**) 09-15-10, 16:14

Hi,

The autofilter class was extensively overhauled in Excel 2007. To be able to give a thorough reply to help you, we really need to know which version of Excel you are using.

dg1069 · #3 (**permalink**) 09-17-10, 01:10

Thanks for your reply. I am working on excel 2007, other than that what version you want to know? Can you give some steps to find the same?

Looking forward for your response.

Internet Services

Web Development

Digital Marketing

Consumer Tech