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...
I admonish you to instead create a dynamic named range for your employee names. For example, if A1 is Employee, and the names of employees are listed below, starting in A2, define “Employees” as a dynamic range with this formula:
=$A$2:INDEX($A:$A,COUNTA($A:$A))
Thereafter, enter this in the source box of your drop-down list:
=Employees
=$A$2:INDEX($A:$A,COUNTA($A:$A))
Thereafter, enter this in the source box of your drop-down list:
=Employees
