software

I have created four lists. List A is the main type list and List B, C and D
are the sub-types. Is it possible that by selecting a value in List A in a
cell, I can call List B, C or D in another cell.
Please help...

i!

Are you talking about data validation drop down lists?

If so, yes, you can do this.

Need more detail for a better solution but in general this is how you would
do it:

The main list would contain the names of all the other lists. The selection
made from that list would dictate which sublist is displayed in the other
cell.

See this:

contextures.com/xlDataVal02.html

Biff

quot;Dire straitsquot; lt;Dire gt; wrote in message
...
gt;I have created four lists. List A is the main type list and List B, C and
gt;D
gt; are the sub-types. Is it possible that by selecting a value in List A in
gt; a
gt; cell, I can call List B, C or D in another cell.
gt; Please help...
Biff,
Thankyou. With the information that you provided made me complete the task
and create the quot;dependant listsquot;.
Thank you very much.

quot;Biffquot; wrote:

gt; i!
gt;
gt; Are you talking about data validation drop down lists?
gt;
gt; If so, yes, you can do this.
gt;
gt; Need more detail for a better solution but in general this is how you would
gt; do it:
gt;
gt; The main list would contain the names of all the other lists. The selection
gt; made from that list would dictate which sublist is displayed in the other
gt; cell.
gt;
gt; See this:
gt;
gt; contextures.com/xlDataVal02.html
gt;
gt; Biff
gt;
gt; quot;Dire straitsquot; lt;Dire gt; wrote in message
gt; ...
gt; gt;I have created four lists. List A is the main type list and List B, C and
gt; gt;D
gt; gt; are the sub-types. Is it possible that by selecting a value in List A in
gt; gt; a
gt; gt; cell, I can call List B, C or D in another cell.
gt; gt; Please help...
gt;
gt;
gt;

PS: I rate the reply five stars *****.

quot;Biffquot; wrote:

gt; i!
gt;
gt; Are you talking about data validation drop down lists?
gt;
gt; If so, yes, you can do this.
gt;
gt; Need more detail for a better solution but in general this is how you would
gt; do it:
gt;
gt; The main list would contain the names of all the other lists. The selection
gt; made from that list would dictate which sublist is displayed in the other
gt; cell.
gt;
gt; See this:
gt;
gt; contextures.com/xlDataVal02.html
gt;
gt; Biff
gt;
gt; quot;Dire straitsquot; lt;Dire gt; wrote in message
gt; ...
gt; gt;I have created four lists. List A is the main type list and List B, C and
gt; gt;D
gt; gt; are the sub-types. Is it possible that by selecting a value in List A in
gt; gt; a
gt; gt; cell, I can call List B, C or D in another cell.
gt; gt; Please help...
gt;
gt;
gt;

You're welcome. Thanks for the feedback! And thanks to Debra Dalgleish for
having a great site!!

Biff

quot;Dire straitsquot; gt; wrote in message
...
gt; Biff,
gt; Thankyou. With the information that you provided made me complete the
gt; task
gt; and create the quot;dependant listsquot;.
gt; Thank you very much.
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; i!
gt;gt;
gt;gt; Are you talking about data validation drop down lists?
gt;gt;
gt;gt; If so, yes, you can do this.
gt;gt;
gt;gt; Need more detail for a better solution but in general this is how you
gt;gt; would
gt;gt; do it:
gt;gt;
gt;gt; The main list would contain the names of all the other lists. The
gt;gt; selection
gt;gt; made from that list would dictate which sublist is displayed in the other
gt;gt; cell.
gt;gt;
gt;gt; See this:
gt;gt;
gt;gt; contextures.com/xlDataVal02.html
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Dire straitsquot; lt;Dire gt; wrote in message
gt;gt; ...
gt;gt; gt;I have created four lists. List A is the main type list and List B, C
gt;gt; gt;and
gt;gt; gt;D
gt;gt; gt; are the sub-types. Is it possible that by selecting a value in List A
gt;gt; gt; in
gt;gt; gt; a
gt;gt; gt; cell, I can call List B, C or D in another cell.
gt;gt; gt; Please help...
gt;gt;
gt;gt;
gt;gt;