See http://www.contextures.com/xlDataVal02.html

--
__________________________________
HTH

Bob

"Betty S" <Betty wrote in message
...
I am using Excel for course scheduling. I have a drop-down menu in one
column with departments. If the user selects a given department, I would
like the next column then to have a drop down menu showing them the names
of
courses available in their department only (rather than one huge list of
all
the course names from all departments). I do not know whether Excel has
a
formula that might work for this instance? If anyone has ideas, I would
be
most grateful. Thank you!