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

On Mar 16, 11:38 pm, Funkster <Funks...@discussions.microsoft.com>
wrote:
> 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

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

On Mar 16, 3:38 pm, Funkster <Funks...@discussions.microsoft.com>
wrote:
> 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