microsoft excel courses in - selecting source external worksh

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses in - Source from an external worksheet for Data Validation

microsoft excel courses in - Source from an external worksheet for Data Validation

resolvedResolved · Low Priority · Version Standard

Edited on Mon 3 Dec 2007, 16:01

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.

Edited on Mon 3 Dec 2007, 16:13

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.

Edited on Mon 3 Dec 2007, 16:22

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


Server loaded in 0.1 secs.