Displaying data based on Drop Down List Selection

[Guest]

Hello, hope someone can help.

I have a list of records in Excel which are attributed to teams in my
organisation. Say its a list of staff. What I need is to be able to send the
file out so that a user can select from a drop down menu the team name and
the list displays all the staff in that team.

I know that they could just use a filter for this themselves but these these
users are not even comfortable doing that!! I need to make is simple so
wanted a big obvious drop down list with the teams in, they select it and see
all the relevant records.

Has anybody got any ideas? Would be very greatful if anyone could help

Thanks

 

[geniusideas]

Hello, hope someone can help.

I have a list of records in Excel which are attributed to teams in my
organisation. Say its a list of staff. What I need is to be able to send the
file out so that a user can select from a drop down menu the team name and
the list displays all the staff in that team.

I know that they could just use a filter for this themselves but these these
users are not even comfortable doing that!! I need to make is simple so
wanted a big obvious drop down list with the teams in, they select it and see
all the relevant records.

Has anybody got any ideas? Would be very greatful if anyone could help

Thanks

You can use data validation to create drop down list.
Select any cell
Go to Tool--Data--Validation
Under Allow Select list.
Under Source you can refer any selected cells Or key in your list
seperated by comma.
Example : steve,alex,baldwin,.....

http://microsoft-excel-macro.blogspot.com

 

[Pete_UK]

Have a look at this link:

http://www.contextures.com/xlDataVal02.html

It shows how to set up dependent lists in data validation.

Hope this helps.

Pete