Been scratching my head with this one. Any help would be absolutely fantastic, a godsend.
So I have a table. I'm looking to extract data after applying various filters.
One of them is the date. I have the date in another cell, and it's in a format of mm/dd/yy.
Here is the code...
ActiveSheet.Range("$K$20:$Q$58").AutoFilter Field:=3, Criteria1:= _ ">=worksheets(1).AA16", Operator:=xlAnd, Criteria2:="05/26/17"
For whatever reason, it's not filtering the thing. It doesn't give me an error message to say it's wrong either.
Can anyone tell me whether this is possible?
PS , I also tried the following, and that didn't work either..