Auto Filter data with 2 different criteria

[BombSheels]

Hello, i have an excel macro file which I need to filter to 2 different criteria.
Criteria1 filter current year
Criteria2 filter specific words

But upon running the macro, it only displays 1 criteria

With Sheet2.Range("A1:F50000")
   
    .AutoFilter Field:=6, _
                Operator:=xlFilterDynamic, _
                Criteria1:=xlFilterThisYear

    .AutoFilter Field:=6, _
               Criteria2:=Array("INCLUDE", "INCLUDE SA"), _
                Operator:=xlFilterValues

  End With

kindly help me. thank you

 

[RoryA]

You can't apply two different types of filter to the same field with an autofilter. You could use an advanced filter instead (which requires a criteria range).

 

[BombSheels]

You can't apply two different types of filter to the same field with an autofilter. You could use an advanced filter instead (which requires a criteria range).

ok will try this one. thank you RoryA