Forum home » Delegate support and help forum » Microsoft Excel Training and help » Dynamic drop down lists
|
|
|
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. |
Dynamic drop down lists
Resolved · Low Priority · Version 2007
Reply Mon 6 Feb 2012, 16:46Delegate Malcolm said...
Malcolm has attended:
Excel Advanced course
Dynamic drop down lists
How do I create a dynamic drop down list, so that the selection made from the first drop down list will limit the choices in a second list?
Thanks
For upcoming training course dates see: Pricing & availability
RE: Dynamic drop down lists
Hi Malcolm, 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.
|