Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linked pick list
|
|
|
The UK's most regular 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. |
Linked pick list
Resolved · High Priority · Version 2007
Reply Mon 6 Feb 2012, 16:47Delegate Jade said...
Jade has attended:
Excel Advanced course
Linked pick list
How do I create a linked pick list? For example, my first list is Region (e.g. Europe) but I want the next list to have only the countries in that particular region (e.g. UK, Spain etc etc).
For upcoming training course dates see: Pricing & availability
RE: Linked pick list
Hi Jade, thanks for your query. What you are trying to create is a dependent drop down using data validation. There are some good walkthroughs here:
http://www.contextures.com/xldataval13.html
http://www.ozgrid.com/Excel/dependent-lists.htm
Hope this helps,
Anthony
Mon 13 Feb 2012: Automatically marked as resolved.
|