Source from an external worksheet for Data Validation
Is it possible to select a list of names from another worksheet within the same workbook for setting up with Data Validation? I have tried endlessly on this topic, but have not found a way as yet. Thank you.
RE: Source from an external worksheet for Data Validation
Yes at long last I have found a way to do this.
Create a range name for the list of names on the worksheet e.g. names
Go to the worksheet where the data validation is to be set up.
Select the cells required for Data validation.
Select Data, Validation
Settings tab, Allow, choose List
Fill in source with =names
Fill in Input Message and Alert Message,
Click OK
The drop down list now uses the data from the external worksheet within the same workbook.
RE: Source from an external workbook for Data Validation
Also if you have the source data in another workbook
Create a range name for the list of names on a worksheet in Workbook A e.g. external_names
Go to workbook B and worksheet where the data validation is to be set up.
Create a range name e.g. external_list
Then type in the Refers to: =workbookA.xls!external_names
Select the cells required for Data validation.
Select Data, Validation
Settings tab, Allow, choose List
Fill in source with =workbookA.xls!external_names
Fill in Input Message and Alert Message,
Click OK
The drop down list now uses the data from the external Workbook A.
RE: Source from an external workbook for Data Validation
Data Validation is covered on our Excel Advanced Course, please check our website for Syllabus.
Thank You
Sandy
