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