Return a list dependent upon the selection of a preceeding list
 

I am creating a form defined by Category, Item, and sub-item. I would like
to be able to select the category from a list. Then dependent upon that
answer I would like to be able to select the appropriate item from that
specific Category list and so on. How can I do this?
--
Thank you kindly,
Aja

Return a list dependent upon the selection of a preceeding list
 

See Debra Dalgleish's instructions for using Dependent Lists:
http://www.contextures.com/xlDataVal02.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Aja K" wrote:

I am creating a form defined by Category, Item, and sub-item. I would like
to be able to select the category from a list. Then dependent upon that
answer I would like to be able to select the appropriate item from that
specific Category list and so on. How can I do this?
--
Thank you kindly,
Aja

Return a list dependent upon the selection of a preceeding list
 

http://www.contextures.com/xlDataVal02.html


--
Regards,

Peo Sjoblom



"Aja K" wrote in message
...
I am creating a form defined by Category, Item, and sub-item. I would like
to be able to select the category from a list. Then dependent upon that
answer I would like to be able to select the appropriate item from that
specific Category list and so on. How can I do this?
--
Thank you kindly,
Aja

Return a list dependent upon the selection of a preceeding lis
 

You rock Ron. This is what I was hunting for.
--
Thank you kindly,
Aja


"Ron Coderre" wrote:

See Debra Dalgleish's instructions for using Dependent Lists:
http://www.contextures.com/xlDataVal02.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Aja K" wrote:

I am creating a form defined by Category, Item, and sub-item. I would like
to be able to select the category from a list. Then dependent upon that
answer I would like to be able to select the appropriate item from that
specific Category list and so on. How can I do this?
--
Thank you kindly,
Aja

Return a list dependent upon the selection of a preceeding list
 

Aja

Check out Debra Dalgleish's site for dependent lists using Data Validation
drop-downs.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Wed, 11 Apr 2007 10:26:01 -0700, Aja K
wrote:

I am creating a form defined by Category, Item, and sub-item. I would like
to be able to select the category from a list. Then dependent upon that
answer I would like to be able to select the appropriate item from that
specific Category list and so on. How can I do this?