software

I think this question has been answered before but i can't seem to find
anything related to it. I wonder if this is even possible?

I have about four items on the first validation list that i can choose from,
and based on what is chosen on that list, the second validation list should
only show the list of items that are related to what is chosen on the first
validation list.

For example, on the first validation list, there are these items: A, B, C, D.

A has 1, 2, 3, 4
B has 5,9,30,2
C has 0, 12, 6, 10
D has 66,44,33,22

If i choose A, then the second validation list should only list only 1, 2,
3, or 4 as choices.

and if i choose B, the second validation should only show what is related to
B, etc.

Any help is appreciated. Thanks in advance.
See this page of Debra Dalgleish's Contextures website:

Dependent Lists:
www.contextures.com/xlDataVal02.html

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Michaelquot; wrote:

gt; I think this question has been answered before but i can't seem to find
gt; anything related to it. I wonder if this is even possible?
gt;
gt; I have about four items on the first validation list that i can choose from,
gt; and based on what is chosen on that list, the second validation list should
gt; only show the list of items that are related to what is chosen on the first
gt; validation list.
gt;
gt; For example, on the first validation list, there are these items: A, B, C, D.
gt;
gt; A has 1, 2, 3, 4
gt; B has 5,9,30,2
gt; C has 0, 12, 6, 10
gt; D has 66,44,33,22
gt;
gt; If i choose A, then the second validation list should only list only 1, 2,
gt; 3, or 4 as choices.
gt;
gt; and if i choose B, the second validation should only show what is related to
gt; B, etc.
gt;
gt; Any help is appreciated. Thanks in advance.
gt;
gt;

Hey Ron,

Thanks a whole bunch for website--it was very helpful!

quot;Ron Coderrequot; wrote:

gt; See this page of Debra Dalgleish's Contextures website:
gt;
gt; Dependent Lists:
gt; www.contextures.com/xlDataVal02.html
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Michaelquot; wrote:
gt;
gt; gt; I think this question has been answered before but i can't seem to find
gt; gt; anything related to it. I wonder if this is even possible?
gt; gt;
gt; gt; I have about four items on the first validation list that i can choose from,
gt; gt; and based on what is chosen on that list, the second validation list should
gt; gt; only show the list of items that are related to what is chosen on the first
gt; gt; validation list.
gt; gt;
gt; gt; For example, on the first validation list, there are these items: A, B, C, D.
gt; gt;
gt; gt; A has 1, 2, 3, 4
gt; gt; B has 5,9,30,2
gt; gt; C has 0, 12, 6, 10
gt; gt; D has 66,44,33,22
gt; gt;
gt; gt; If i choose A, then the second validation list should only list only 1, 2,
gt; gt; 3, or 4 as choices.
gt; gt;
gt; gt; and if i choose B, the second validation should only show what is related to
gt; gt; B, etc.
gt; gt;
gt; gt; Any help is appreciated. Thanks in advance.
gt; gt;
gt; gt;