Sheets - Select from dropdown list - Reduce list by selection

Viewed 13

I'm creating a list of employees and giving them station assignments from a drop down list. Once I assign a station I'd like that option to be removed from the list. If I go back and deselect the assignment I would like it to be re added to the list.

Is this possible in sheets?

Thank you in advance!

0 Answers
Related