Google sheets help

[Saddlesoap]

Any clever IT / spreadsheet savvy Tattlers able to help me?

I've created a spreadsheet for a work rota using data validation and drop down boxes with staff names.

I've figured out a way to ensure that each cell is unique (so I can't accidentally rota the same person twice). BUT!

Is there a way to hide a person from the drop down list once I have selected them, effectively reducing my options for which staff I have as I work through the rota.

Hope that makes sense!

 

[Dogtanian]

Hope this helps :

Remove used selection from Drop-Down List in Google Sheets - Google Docs Editors Community