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!