I have created a Data Validation list for the employees and added it to the Calendar sheet. Where you can now select them from the list. All need to do to maintain is the list on the Employees tab. I wasn't sure about the Admins, whether they should be together with the employees or not.
Bookmarks