Hi DTG,

fi_mgr_num = Sheets("reports").Range("I6")
Selection.AutoFilter Field:=2, Criteria1:="=" & fi_mgr_num,
Operator:=xlAnd

This worked for me, provided that a cell in the autofilter range was
pre-selected.

If the first autofilter column only had a single criterion, you could
dispense with:

, Operator:=xlAnd

Did you try it and, if so, what problems did you experience?

---
Regards,
Norman



"dtg_denver" wrote in message
...
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.