SOLVED

Data Validation: How do I add items to a drop-down list that are in another worksheet?

Brass Contributor

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?

 

 

 

 

1 Reply
best response confirmed by yo_Ashley (Brass Contributor)
Solution

@yo_Ashley 

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 best response

Accepted Solutions
best response confirmed by yo_Ashley (Brass Contributor)
Solution

@yo_Ashley 

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.

View solution in original post