If you take a look on the attached spreadsheet you will see a section with Departments and the employees who work within that department. I would like to get the names from the range D26:G29 as the validated data for the range J4:NJ18. Any suggestions on the best way I can achieve this would be appreciated.
I am aware that could just list these names, if this is the only solution other than VB is there a way to automatically add names within the range to a list.
Excel 2003
Bookmarks