Forum Discussion
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 worksheet. https://uncw4-my.sharepoint.com/:v:/g/personal/adamsab_uncw_edu/EdtaGW_LQM1CpYUEjHLNtYABpHTss_cEVkW0CXSWNzRJ9Q?e=ObWyCl.
How do I add items to a drop-down list that is in another worksheet?
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.
1 Reply
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.