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.

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.

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.