Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Lists
I have a roster of volunteers that I am trying to get into a calendar format.
There are three rotations and several groups within each rotation (Greeters, Setup, Sound, Teardown, etc). What I would like to be able to do is to have a cell there you enter the name of the rotation (Team A, B, C). Below that I would like a drop down menu that would give me a list of the groups. When I select a group, I would like the names of volunteers to be populated in the cells below. I feel like there has to be logical statements involved (If cell 1 equals "TEAM A" and cell 2 equals "Set-Up" then cells 3-5 equal Jimmy, Bobby, Susie) and possibly a macro but I'm not sure. Does anyone know of a way to do this? Thanks, HDWT |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Lists
This is a dynamic validation list job, have a look at
http://www.contextures.com/xldataval02.html You can find more help via a Google search with keywords "dynamic validation list" Regards, Stefi €˛Have_Data_Will_Travel€¯ ezt Ć*rta: I have a roster of volunteers that I am trying to get into a calendar format. There are three rotations and several groups within each rotation (Greeters, Setup, Sound, Teardown, etc). What I would like to be able to do is to have a cell there you enter the name of the rotation (Team A, B, C). Below that I would like a drop down menu that would give me a list of the groups. When I select a group, I would like the names of volunteers to be populated in the cells below. I feel like there has to be logical statements involved (If cell 1 equals "TEAM A" and cell 2 equals "Set-Up" then cells 3-5 equal Jimmy, Bobby, Susie) and possibly a macro but I'm not sure. Does anyone know of a way to do this? Thanks, HDWT |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down Lists: Allow option of adding own data if not in drop do | Excel Worksheet Functions | |||
How to create 2 dependent drop down lists from 1 original drop dow | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions |