brian.m.george
New Member
- Joined
- Aug 25, 2009
- Messages
- 1
I am looking to use excel as a scheduling tool with the use of drop down boxes. What I need is a drop down box that picks from a list, and once a selection is made, that selection is no longer available to the other drop down boxes.
For example, let's say I have three people: Bill, John, Sue. There are three times to work: morning, afternoon, evening. The times will be hard coded into column A. In column B, I want three drop downs that pull from the list of available names. Once I task Bill to work in the morning, I would like to only see John and Sue names available on the second and third drop down since the first one has Bill. Does this make sense?
I know I can do this with VBA, but I'm trying to see if excel has anything simpler that allows me to modify the drop down lists real time.
Can anyone help?
For example, let's say I have three people: Bill, John, Sue. There are three times to work: morning, afternoon, evening. The times will be hard coded into column A. In column B, I want three drop downs that pull from the list of available names. Once I task Bill to work in the morning, I would like to only see John and Sue names available on the second and third drop down since the first one has Bill. Does this make sense?
I know I can do this with VBA, but I'm trying to see if excel has anything simpler that allows me to modify the drop down lists real time.
Can anyone help?
