ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro function needed for varied searches using a data filter (https://www.excelbanter.com/excel-programming/339085-macro-function-needed-varied-searches-using-data-filter.html)

CC_rider

Macro function needed for varied searches using a data filter
 
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.


All times are GMT +1. The time now is 02:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com