Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2010
    Posts
    13

    Unanswered: Autofilter problem

    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!!!

  2. #2
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    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.

  3. #3
    Join Date
    Apr 2010
    Posts
    13
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •