Good evening all
I'm looking for some assistance with an advanced filter please,,, been distracting me for a few hours now......
I have 2 advanced filters which are nearly identical one for Sections/Departments,, this one is working perfectly.
The one I'm having trouble with is to filter department training. This is only returning 1 line from the list criteria...
I am using this code. The 'FilterSecDep' is working perfectly... the 'FilterTrg' has the issue
Many thaks for the help
Jim
Sub FilterTrg()
Sheet3.Range("AA1").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Sheet3.Range("AF1:AF2"), CopyToRange:=Sheet3.Range("AG1:AH1"), Unique:=False
End Sub
Sub FilterSecDep()
Sheet3.Range("S1").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Sheet3.Range("V1:V2"), CopyToRange:=Sheet3.Range("W1"), Unique:=False
End Sub
Bookmarks