Lists referencing lists...is it possible?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JohnB - 18 Oct 2006 17:06 GMT

I am looking to create two different lists for users to chose from. However,
I would like the second list to be dependent upon the item selected in the
first list. Is this possible?

Reply to this Message

Ron Coderre - 18 Oct 2006 17:30 GMT

Try using Data Validation with Dependent Lists:

Debra Dalgleish's website shows you how:
http://www.contextures.com/xlDataVal02.html

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

XL2002, WinXP

> I am looking to create two different lists for users to chose from. However,
> I would like the second list to be dependent upon the item selected in the
> first list. Is this possible?

Reply to this Message

JohnB - 18 Oct 2006 18:37 GMT

That is EXACTLY what I need...thank you so much.

jb

> Try using Data Validation with Dependent Lists:
>
[quoted text clipped - 11 lines]
> > I would like the second list to be dependent upon the item selected in the
> > first list. Is this possible?

Reply to this Message