View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
myssieh myssieh is offline
external usenet poster
 
Posts: 15
Default Displaying Drop down list items based on selection of another colu

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