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.