Excel Tutorial Library header
borderControl the Contents of Drop Downlist from a cellborder
border Added to Library on 19 Aug 2007
Length: 3 mins

View Tutorial Movie
Download File Used



This advanced tutorial show you how to control the contents on a data validation drop down list based on the contents of a cell or another dropdown list.

In the turorial the list of students available in the right hand list is controlled by the class already selected.


Related Tutorials:
Adding Drop Down Lists to your Speadsheet
Dynamic References to External Spreadsheets
Introduction to Named Ranges

Feedback for this tutorial:
"To the point, very useful, explained well, the instructor in the vedio is easy to understand and follow."

"So helpful - I have often wanted to do this - but
could not find any detail ! Thanks"


borderborder