Greetings,
I have a master list of company personnel names saved as a table - named "Personnel" - on a hidden "Settings" worksheet. Names are ordered by seniority, then alphabetically. I use that table as source for a personnel dropdown list in a few spots in my workbook via INDIRECT formula.
On one of my worksheets ("Detail Sheet"), selections from the master list are input into cells B16:61. Not all names are used every time, selections change, and are not entered according to the ordering scheme described above.
Is there a way to create a dropdown list elsewhere that references the master "Personnel" table (for seniority/alphabetical ordering), but have it contain only the unordered names that are included on "Detail Sheet"?
Hope that makes sense. Thanks!
I have a master list of company personnel names saved as a table - named "Personnel" - on a hidden "Settings" worksheet. Names are ordered by seniority, then alphabetically. I use that table as source for a personnel dropdown list in a few spots in my workbook via INDIRECT formula.
On one of my worksheets ("Detail Sheet"), selections from the master list are input into cells B16:61. Not all names are used every time, selections change, and are not entered according to the ordering scheme described above.
Is there a way to create a dropdown list elsewhere that references the master "Personnel" table (for seniority/alphabetical ordering), but have it contain only the unordered names that are included on "Detail Sheet"?
Hope that makes sense. Thanks!
