Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2006

Tip: Looking for answers? Try searching our database.

validation list--list depends on the selection of first list

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Michael - 27 Apr 2006 21:43 GMT
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.
Ron Coderre - 27 Apr 2006 21:45 GMT
See this page of Debra Dalgleish's Contextures website:

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

Does that help?

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

XL2002, WinXP-Pro

> 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?
[quoted text clipped - 18 lines]
>
> Any help is appreciated.  Thanks in advance.
Michael - 27 Apr 2006 22:23 GMT
Hey Ron,

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

> See this page of Debra Dalgleish's Contextures website:
>
[quoted text clipped - 31 lines]
> >
> > Any help is appreciated.  Thanks in advance.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.