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

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

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 -

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

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

--
Regards,
Tom Ogilvy


"serge201" wrote:

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

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.



Steve wrote:

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 -

--

Dave Peterson