Displaying Drop down list items based on selection of another colu

M

myssieh

Good Morning!! I am running Excel 2003.

Is there a way to display items from a dropdown list based on what is
selected in another column.

For example... Column D has a list of Work Flow's in it and Column E has
catagories where I used Data Validation to create both dropdown lists...
If a user selectes Intakes workflow in Column D then only three items from
the drop down list in Column E (A,B,C) will be displayed as options.

I hope this makes sense and I thank you in advance for any help you can give
me. I really appreciate it...

Myssie
 
Top