Forum Discussion
Employee Absence Schedule Template
I have entered the names of 20 employees into the Employees Tab, but only the first 5 appear in the drop-down lists for each month. How can I get the other 15 employees to appear in each month's drop...
The template that looks like this?
If not, please point us to the template that you are using.
Ian_C1945 OK! I had a closer look at this template and, as usual, find it not very well designed. It has several flaws, one of which is the the data validation (DV) issue you noticed.
It should work, but somehow, the designer managed to break something. I fixed it on the January and February tab, but it will only work if you are on a modern Excel version that supports dynamic arrays.
The DV list is set up as follows (note the # sign at the end):
But, as said, it should work by pointing at the Employee Name table, but it doesn't. Don't know why and I've given up looking for the reason.
See attached.
- Hi Riny
Thank you for your help.
Regards
Ian