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.
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"