98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
Resolved · Low Priority · Version Standard
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Percentage formatCtrl+Shift+% applies the Percentage format, with no decimal places. |