SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-2882307%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Validation%3A%20How%20do%20I%20add%20items%20to%20a%20drop-down%20list%20that%20is%20in%20another%20worksheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2882307%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383741%22%20target%3D%22_blank%22%3E%40ashleyb_adams%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20create%20a%20named%20range%20that%20refers%20to%20the%20table%20on%20the%20other%20sheet.%3C%2FP%3E%0A%3CP%3EIn%20the%20attached%20version%20I%20defined%20the%20name%20Different_Sheet%20that%20refers%20to%20%3DTable3%5BNew%20State%5D%3C%2FP%3E%0A%3CP%3EI%20set%20the%20data%20validation%20rule%20to%20refer%20to%20%3DDifferent_Sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2882232%22%20slang%3D%22en-US%22%3EData%20Validation%3A%20How%20do%20I%20add%20items%20to%20a%20drop-down%20list%20that%20are%20in%20another%20worksheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2882232%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20drop-down%20list%20does%20not%20reflect%20new%20entries%20added%20to%20it's%20source%20table%20if%20the%20table%20is%20in%20another%20worksheet.%20It%20does%20reflect%20new%20entries%20added%20to%20the%20source%20table%20if%20the%20table%20is%20on%20the%20same%20worksheet.%20%3CA%20href%3D%22https%3A%2F%2Funcw4-my.sharepoint.com%2F%3Av%3A%2Fg%2Fpersonal%2Fadamsab_uncw_edu%2FEdtaGW_LQM1CpYUEjHLNtYABpHTss_cEVkW0CXSWNzRJ9Q%3Fe%3DObWyCl%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ESee%20video%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20add%20items%20to%20a%20drop-down%20list%20that%20is%20in%20another%20worksheet%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2882232%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional 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 ashleyb_adams (Occasional Contributor)
Solution

@ashleyb_adams 

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.