hindersaliva
asked on
Excel VBA - extend Advanced Filter code
This does what I want, but I need to extend it a bit.
I need the Range to be already filtered by this criteria. Field 26 = "Application"
I tried adding Field:=26, Criteria1:="Application" (a wild guess from AutoFilter!) but that did not work.
Thanks for any help.
Range("A16:AH6000").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("AM1"), Unique:=True
I need the Range to be already filtered by this criteria. Field 26 = "Application"
I tried adding Field:=26, Criteria1:="Application" (a wild guess from AutoFilter!) but that did not work.
Thanks for any help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
add the foloowing to cells a6010 and a6011 (the column header and then the criteria , it must be in the format ="=criteria" (equal sign, quotes, equal sign, criteria , quotes):
a6010 : Field 26
a6011 ="=Application"
Open in new window