cascading combo boxes...???

[Gurps]

is there any way in which I can get the selection from one combo box to influence the second?? In other words, The second combo box is dependant on the first.
I am using Excel XP.

any help would be appreciated.
cheers

 

[Aladin Akyurek]

This is the list in B2 <TABLE style="WIDTH: 60pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=80><COLGROUP><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 2925" width=80><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 60pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20 width=80>PS3list</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20>Wii</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20>PC</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20>XBOX</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20>DS</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20>Accessories</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20>Consoles</TD></TR></TBODY></TABLE>

These correspond to the sheet names in the work book, each sheet has has each sheet has 4 columns; A=Product Code, B=Description, C=Qty, D=Price.

Right.

On another sheet, cell B2 brings up the list above, cell C2 has data validation as "List" and source as "=Indirect(B2) which gives the list of product codes for the selection in B2. What I would like to do is bring the cost over at the same time. Hope this makes sense.

Another B2 with the same list of the sheet names... However, I don't understand, how you get a list of product codes with:

=INDIRECT(B2)

for B2 just is a sheet name.

 

[greenie532]

I'm not explaining this very well, can I post the spreadsheet on this site ?

 

[Peter_SSs]

I'm not explaining this very well, can I post the spreadsheet on this site ?

You cannot attach an actual file but you can post small screen shots. Here is a few ways to investigate:

Excel jeanie
or
RichardSchollar’s beta HTML Maker - see the red text in his signature block at the bottom of his post
or
Borders-Copy-Paste

 

[cptnemo]

This process allows for each selection to be shown in separate columns. If I want to use nested dropdowns where the first dropdown links to a second (and/or third as needed) AND the final selection is what shows up in the cell; is this possible and if so, how?

e.g.: I select A1 which brings up menu "Countries." I select "England" which brings up 'Cities.' I select "London" and this is placed in cell A1.

 

[Sudhish]

That was gr8. Thax dear.

 

[proficient]

Aladin!

You are awesome