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...
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