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-down list?
When using Data Validation/Settings the option "Source" does not appear?
Regards
Ian
1. select the range where you want to apply data validation:
2. Click on Data --> Data validation
3. Choose list, then source option will appear:
4. Select range where employee names are written.
you may also refer attached file.
- Thank you Sandeep.
It now works fine.
Regards
Ian
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.
Attached is a text file with dropdowns, think that can help you.
If it doesn't help you, please more information on your topic.
If possible, include the file (without sensitive data).
