Return a list dependent upon the selection of a preceeding list

[Guest]

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?

 

[Guest]

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

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

XL2002, WinXP

 

[Peo Sjoblom]

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

 

[Guest]

You rock Ron. This is what I was hunting for.

 

[Gord Dibben]

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