Multiple drop down's populated based on previous cell selections

[dhally]

Hello,
I have pasted 3 of the 14 lists of what I am trying to achieve using color combination's to illustrate choices.
<table border="0" cellpadding="0" cellspacing="0" width="1915"><col style="width: 200pt;" width="267"> <col style="width: 269pt;" width="358"> <col style="width: 569pt;" width="758"> <col style="width: 399pt;" width="532"> <tbody><tr style="height: 31.5pt;" height="42"> <td class="xl78" style="height: 31.5pt; width: 200pt;" width="267" height="42">SELECTION LIST (DROP DOWN) Column A:</td> <td class="xl75" style="width: 269pt;" width="358">(INTERMEDIATE) DROP DOWN LIST TO POPULATE Column B:</td> <td class="xl76" style="border-left: medium none; width: 569pt;" width="758">(JACKET LINE) DROP DOWN LIST TO
POPULATE Column B also:</td> <td class="xl77" style="border-left: medium none; width: 399pt;" width="532">(MULTIWIRE LINE) DROP DOWN LIST TO POPULATE</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">INTERMEDIATE #1</td> <td class="xl66" style="border-top: medium none;">ACCUMULATOR</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">CAPSTAN</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">ANNEALER-CERAMIC COATED SHEAVE; STEAM CHANNEL ANNEALER BAND & FRAME</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl72" style="height: 15.75pt;" height="21">INTERMEDIATE #2</td> <td class="xl67">CAPSTAN</td> <td class="xl69" style="border-left: medium none;">CONAIR</td> <td class="xl71" style="border-left: medium none;">DANCER-CAPSTAN; SHEAVE</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">JACKET LINE #1</td> <td class="xl67">CONAIR</td> <td class="xl69" style="border-left: medium none;">DAVID STANDARD (OEM)-EXTRUSION & WATER TROUGH</td> <td class="xl71" style="border-left: medium none;">DRAWBOX-CAPSTAN; CONTACT TUBE</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl73" style="height: 15.75pt;" height="21">JACKET LINE #2



</td> <td class="xl67">DAVID STANDARD (OEM)-EXTRUSION & WATER TROUGH</td> <td class="xl69" style="border-left: medium none;">GRAVIMETRIC FEEDER</td> <td class="xl71" style="border-left: medium none;">HENRICH (OEM)-MULTIWIRE #1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt;" height="20">
</td> <td class="xl67">GRAVIMETRIC FEEDER</td> <td class="xl69" style="border-left: medium none;">HEATER-BARREL; BAND; THERMOCOUPLE</td> <td class="xl71" style="border-left: medium none;">NIEHOFF (OEM)-MULTIWIRE #2</td> </tr> </tbody></table>


In column (A) I have the main drop down selections listed in red and blue w/black header. In the adjacent columns I have the associated drop down selections listed by same color. In all, I have 13 total drop down list possibilities.

So, 1 main selection list and 13 possible drop down lists.

On a clean sheet, if a person chooses say, Intermediate #1 from the main selection list (highlight in red) in Column A1, a drop down list will populate in the adjacent Column B1 cell with the appropriate information highlighted in red. (I'm sure I would have to create the 13 drop down lists somewhere as separate named ranges).

Likewise, if a person chooses Jacket Line #1 (blue highlight) from the main drop down list in Column A, it's drop down list (also in blue) will populate in the adjacent B1 cell and likewise for other choices in the main selection list for a total of 13 possible drop down lists to be populated in the same B1 cell based on the adjacent A1 cells listed choices.

Hope this makes sense. I have the spreadsheet if needed. Thank you.

 

[ColinKJ]

Hi dhally,

If you do a seach here on the forum for Dependent Validation you should find a few posts on this subject.

I put togeter an example WB called Multi_Dependant Validation.xls for another user a while back, which you can download from:

http://www.box.net/shared/t1lobn7han65obv6dlsq

 

[dhally]

Hi dhally,

If you do a seach here on the forum for Dependent Validation you should find a few posts on this subject.

I put togeter an example WB called Multi_Dependant Validation.xls for another user a while back, which you can download from:

http://www.box.net/shared/t1lobn7han65obv6dlsq

Thank you ColinKJ for your reply. I will have to wait until I get to my home pc tonight to view your link. The access to the 52kb WB download for some reason is blocked by this companies server.