Hide rows via Pulldown

[Steve]

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!!

 

[Guest]

Steve,

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

 

[Steve]

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.

 

[Guest]

Jsut select the two columns header you need before puting autofilter on, it
will limit two the two columns you want

 

[Guest]

Wouldn't that work only if the columns are adjacent/contiguous?

 

[Dave Peterson]

You can apply the autofilter to the entire range and hide the arrows you don't
want to see.

Debra Dalgleish shows how:
http://contextures.com/xlautofilter03.html#Hide

Personally, as a user, I'd rather see those arrows on all the fields. You may
not think I want to filter by a certain field, but I may decide later that I
do. So I wouldn't want you to limit my choices.