Yes, but - the autofilter puts the arrow on EVERY column, and I have
33 of them populated with data. The exec staff only wants to filter
on 2 of the columns. Plus, we were hoping to do something on a
different "input sheet" rather than have to make adjustments directly
on the data sheet. So I kind of need limited functionality of
autofilter.

On Aug 3, 10:16 am, Vergel Adriano
wrote:
Steve,

The AutoFilter feature should do the trick. In the main menu, go to
Data-Filter-AutoFilter.

--
Hope that helps.

Vergel Adriano



"Steve" wrote:
Hello all. I have a data sheets with lots of personnel info. I would
like to create 2 pulldown menus that will hide rows. In column A I
have department. In column B I have status. How can I have the user
select a department from the "Department" pulldown, and a status from
the "status" pulldown and have the data sheet hide all rows OTHER than
the selections? I guess I would also need an "All" selection for each
of the categories. Essentially it sounds like an autofilter, but for
the executive staff I need something with a simpler front end. Thanks
for any and all help!!- Hide quoted text -

- Show quoted text -