Hello!
This is my first time using a forum and I have fairly basic Excel skills so hopefully I'm giving you all of the information you need to help me.
I want to roster staff by choosing the staff member from a validation list [Roster Sheet of attached spreadsheet]. However, I want the staff members available in this list to be determined by whether the cell is blank (ie they are NOT on leave) [Availability Sheet of attached spreadsheet]. For example, Jack Black is on annual leave on 1st and 2nd January so Jack should not show on the drop down list in the Roster sheet on these two days.
Hoping someone can help me as I'm pulling my hair out :-(
Thanks for your assistance ... it's very much appreciated.
Jazz
Bookmarks