Forum Discussion
table references for drop down
I have created table1 on tab Empl By Dept with headers for Employee, supervisor and dept. I am using a drop down list on another tab of the same workbook to select data from this table. Per excel he...
The data validation menu doesn't accept structured table references for list sources. The workaround is to define a named item inside of your table (It will expand with the table as needed).
I am not seeing anywhere to define a named item as shown in the pic.
- I did not get an error. it seemed to work, but if I chose a name from the drop down in my spreadsheet, then went to the source table and modified that name, it did not change the name in the drop down list selection to the modified name. I thought that was the whole point of using table references instead of cell references.