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 working with there are only 5 listed. Help!
Thanks,
Lainey
10 Replies
You have done just about everything right. It is not your fault that Microsoft has not got around to recognising structured references (here, the Table 'EmployeeName') for validation lists.
All you have to do is hide the structured reference within a name. In this case I defined a new Name 'EmployeeValidation' to refer to the Table 'EmployeeName'.
This definition means that the list is dynamic and the validation list remains pointing to the entire table even when additional names are added.
- 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 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
