Hi
Sorry I am a really novice user of excel. I am trying to create a template with dropdown lists to help write a daily roster. Is there any way you can link the drop-down lists in a column and or row such that the item is then removed from the other lists?
For example in rostering people: if the main drop down list has all the available people for the day, but then once I put someone on checkout, I would like them removed from the option of supervisor. If I then later made changes and removed them from the checkout, would they reappear as an option for supervisor? thanks
