Oct 25 2021 08:31 AM - edited Oct 26 2021 12:51 PM
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. See video.
How do I add items to a drop-down list that is in another worksheet?
Oct 25 2021 08:41 AM
SolutionYou 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.
Oct 25 2021 08:41 AM
SolutionYou 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.