Displaying data based on Drop Down List Selection

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...


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
 
Back
Top