I'm using a data filter to search for a specific row items so my search is
different every time. Is there a function or method that I could I (use in
conjunction w\the macro below ) to input new search criteria while using this
Autofilter field...
This is what I have so far :
Windows("Sheet1.xls").Activate
Windows("Sheet2.xls").Activate
Windows("Sheet1.xls").Activate
Selection.AutoFilter Field:=11, Criteria1:="="
Selection.AutoFilter Field:=3, Criteria1:="=*7l54*3504*aa*", Operator:= _
xlAnd

THX.