<

Linked dropdowns in MS Excel

Published on
7,709 Points
3,009 Views
7 Endorsements
Last Modified:
Linked Data Validated dropdowns in Excel

Creating a Data Validated dropdown is a straightforward task, however every now and again the question comes up of "How do I make the contents of a second dropdown change depending upon the choice made in the first drop down"

As there are embedded screenshots in my 'How to' notes I am attaching an MS Word file which has full instruction on how to do it.

Hope it helps someone.

Patrick
Linked-dropdowns-02.doc
7
Author:patrickab
Ask questions about what you read
If you have a question about something within an article, you can receive help directly from the article author. Experts Exchange article authors are available to answer questions and further the discussion.
Get 7 days free