Difficult filter question

[Xndman]

Hi,
I was wondering if there was any way to filter a list at some point in a spreadsheet without that point being the actual column filtered. For example:

Dept Mgr Mgr Stats Fin Stats
OR Joe Minutes Revenue
Cases
Rooms
Cafeteria Lou Meals Served Revenue
Guests
Purchasing Carol Items Purchased Cost

In the above example, is there any way that I can create a box where each Mgr types in their name and their related info (Dept, Mgr, Mgr Stats, Fin Stats) pops up? If not, can I filter on Mgr without actually having the drop down box above Mgr?

Thanks for your help.

[PaddyD]

In general, that sort of thing requires an advanced filter, not the autofitler - check it out in the help. However, if your posted data is representative, you will have problems filtering for each manager with all those blanks...