| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFilter Pull Criteria from one sheet and custom filter on other
I'm trying to Custom Autofilter on a sheet by pulling the criteria from a
drop down list on another sheet. Here is how I have been trying to do it. fi_mgr_num = Sheets("reports").Range("I6") Selection.AutoFilter Field:=2, Criteria1:="=" & fi_mgr_num, Operator:=xlAnd I don't have a clue if this is close, but I saw some of these ideas here on the forum and have been trying various interations to make it work. Any help would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I filter for a blank cell, using custom autofilter | Excel Discussion (Misc queries) | |||
| AutoFilter: custom filter hides all | Excel Worksheet Functions | |||
| saving autofiltercustom filter settings | Excel Worksheet Functions | |||
| can custom autofilter pull parameters from other data? | Excel Discussion (Misc queries) | |||
| Shortcut for Filter- Custom Autofilter | Excel Discussion (Misc queries) | |||
Threaded Mode
