Forum Discussion
Solved
Data Validation: How do I add items to a drop-down list that are in another worksheet?
My drop-down list does not reflect new entries added to it's source table if the table is in another worksheet. It does reflect new entries added to the source table if the table is on the same works...
You can create a named range that refers to the table on the other sheet.
In the attached version I defined the name Different_Sheet that refers to =Table3[New State]
I set the data validation rule to refer to =Different_Sheet.
You can create a named range that refers to the table on the other sheet.
In the attached version I defined the name Different_Sheet that refers to =Table3[New State]
I set the data validation rule to refer to =Different_Sheet.