Forum Discussion
Template Employee absence schedule
Hi, I'm using the template Employee absence schedule but I can't add more than 5 employees. I can add them in the sheet 'names' but i can't select them in the months... Am I missing something?...
They have used data validation in creating the items you can select in the months tabs. In order to select any new employee added on the names tab, you have to update the source on the data validation to pick all the new cells added. See below:
To do this, go to Data, select data validation under Data tools group
I have attached an updated workbook for you.
Do let me know if this works,
Cheers
wumolad Can you please send me an updated on with about 80 employees? May not need all 80 but staff changes all the time and I manage the COVID Testing sites in CA so want to be able to track everything easier than pen and paper.