New Excel Forum

This forum has been moved to TeachExcel.

Ask all future questions in the new excel forum.

ExcelKey

Change the validation list in one drop-down dependent upon the selection in another

Free Excel Tips and Tutorials
Forum rules
This forum is closed.

All new posts should be made at our new Excel Forum at TeachExcel.com.

Change the validation list in one drop-down dependent upon the selection in another

Postby Sisyphus » Fri Oct 12, 2012 5:32 am

The attached workbook has the entire set-up required to create two drop-down lists where the second one takes on a different list to select from dependent upon which selection was made in the first. Everything is explained by example of the case created in the workbook. Note, however, that you can substitute absolute cell and range references for the named ranges used in the example should you not be comfortable with named ranges.
You do not have the required permissions to view the files attached to this post.
Have a great day! :D

Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
Sisyphus
Former Moderator
 
Posts: 4454
Joined: Dec 7, 2011
Location: Shanghai
Reputation: 203
Excel Version: 2010

Return to Excel Tips and Tutorials

Who is online

Users browsing this forum: No registered users and 1 guest