Forum Discussion
Employee Absence Schedule
I can't seem to get all my employees to show up under the drop down menu after I have added them to the list. They show up on the Employee Name tab but when I go to add them to the month that I am w...
Hello Lainey,
Would you mind sharing your excel workbook? I can't quite figure out why you might be experiencing this issue and I'd like to take a closer look.
**Please remember to remove any confidential information
Thank you!
PReagan
In the reply screen, scroll to the bottom and you will see a small paper clip icon. Click this to add a file.
PReagan
It looks like the problem was that the source of your data validation list was ='Employee Names'!$B$4:$B$8 when instead it should have been ='Employee Names'!$B$4:$B$12. I fixed this issue but only for the August tab. You may copy the cells from the August tab to the other monthly tabs if you would like to have the same list in each tab.
Hope this helps!
PReagan