I am trying to set up an advanced filter with multiple criteria range ( And, Or operators ) the problem is when I run the code the results that appear are related to the last row in the criteria range while the previous rows are missing
According to the code Num refers to the last row in the criteria table (F to I)
If Sheet11.Range("P2,Q2,R2").Value <> Empty Then
Set AFCRange = Sheet1.Range("F3:I" & Num) 'Advanced Filter Criteria Range
Sheet13.Range("I1:A" & lastRow).CurrentRegion.AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=AFCRange, _
CopyToRange:=Sheet3.Range("K2:C2"), Unique:=False
End If
End With