List that brings up another List
I have a list created in a cell. I desire to have another second list
displayed in a different cell that will change with the selection made from the first list. Example Cell A1 contains a list of "Vehicle Types" (truck, car, van, other) I would like Cell A5 to bring up another list for the color options (red, blue, green, etc.) The list in cell A5 will completely different dependant upon what is selected in cell A1. |
List that brings up another List
Check out the below link from Debra on "Data Validation -- Dependent
Dropdowns from a Sorted List " http://www.contextures.com/xlDataVal13.html If this post helps click Yes --------------- Jacob Skaria "bazsil,73" wrote: I have a list created in a cell. I desire to have another second list displayed in a different cell that will change with the selection made from the first list. Example Cell A1 contains a list of "Vehicle Types" (truck, car, van, other) I would like Cell A5 to bring up another list for the color options (red, blue, green, etc.) The list in cell A5 will completely different dependant upon what is selected in cell A1. |
List that brings up another List
Check out this example:
http://www.contextures.com/xldataval02.html May do what you want. Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "bazsil,73" wrote: I have a list created in a cell. I desire to have another second list displayed in a different cell that will change with the selection made from the first list. Example Cell A1 contains a list of "Vehicle Types" (truck, car, van, other) I would like Cell A5 to bring up another list for the color options (red, blue, green, etc.) The list in cell A5 will completely different dependant upon what is selected in cell A1. |
All times are GMT +1. The time now is 03:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com