Need Help with drop down list with conditions...

G

Guest

I need help.

I'm having a very difficult time creating a sequence of list which change based on the item selected on the main list, lets call it the index:

The Index list, the first list, would define vendors. In this case Hotel Companies (e.g Hilton, Marriott, Sheraton).

The following list, the 2nd list, would define properties, but the properties would vary based on which hotel company is selected (e.g. If Hilton, then "The Plaza, the Waldorf Astoria. If Marriott, then Marriott Marquis, Marriott Convention Center etc etc...) on list #1.

And Last but not least, the 3rd list would show the categories available from the selection made from list #2 (e.g. Run of the house, Suite, Penthouse).

I've gone and created colums listing all of the above, but I can't figure out how to set conditions on each list so I can sort out the correct information.

Also note that each drop down will not be adjecent to each other they may be placed in all different areas of the page.

Any help will be greatly appreciated.
 
B

Biff

Have a look here:

http://contextures.com/xlDataVal02.html

Biff
-----Original Message-----
I need help.

I'm having a very difficult time creating a sequence of
list which change based on the item selected on the main
list, lets call it the index:
The Index list, the first list, would define vendors. In
this case Hotel Companies (e.g Hilton, Marriott, Sheraton).
The following list, the 2nd list, would define
properties, but the properties would vary based on which
hotel company is selected (e.g. If Hilton, then "The
Plaza, the Waldorf Astoria. If Marriott, then Marriott
Marquis, Marriott Convention Center etc etc...) on list #1.
And Last but not least, the 3rd list would show the
categories available from the selection made from list #2
(e.g. Run of the house, Suite, Penthouse).
I've gone and created colums listing all of the above,
but I can't figure out how to set conditions on each list
so I can sort out the correct information.
Also note that each drop down will not be adjecent to
each other they may be placed in all different areas of
the page.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top