| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying Drop down list items based on selection of another colu
See:
http://www.contextures.com/xlDataVal13.html -- Gary''s Student - gsnu200769 "myssieh" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying Drop down list items based on selection of another colu
I think this page over at Contextures will help in your quest:
http://www.contextures.com/xlDataVal02.html "myssieh" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying Drop down list items based on selection of another
Thank you so much!!! I appreciate it... Have a great day!!
"Gary''s Student" wrote: See: http://www.contextures.com/xlDataVal13.html -- Gary''s Student - gsnu200769 "myssieh" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to populate a drop down list based on the selection of ano | Excel Discussion (Misc queries) | |||
| count based on selection from drop down list | Excel Worksheet Functions | |||
| Hide row(s) based on drop down selection | Excel Discussion (Misc queries) | |||
| Move entire row to another worksheet based on drop list selection | Excel Worksheet Functions | |||
| limit cell list selection based on the selection of another list | Excel Worksheet Functions | |||
Linear Mode
