Notice
Thread ordered by most liked posts - View normal thread.

Saddlesoap

VIP Member
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!