Validation - Narrowing down choices

[Guest]

I am building a template and one area is a series of 5 questions that need to
be answered using validation lists. The first is "machine brand" then
"machine type" then "machine size" then "machine spacing" then "machine
platen size". The problem is not all machine brands offer the same specs. For
example, "brand X" may offer a 200, 300, 400ton while "brand Y" offers a 225,
350, 450 ton. This is the same concept for all 4 sub-categories. My desire is
for the user to select "machine brand" then have the second validation list
only offer the "machine size" that pertains to that brand. This would be the
same format/concept for all 4 questions. I am somewhat new to validation
lists, but have successfully used dozens already in this file. I am not
sophisticated enough to do what I want and need help. Thanks, Jamie

 

[Gord Dibben]

Jamie

Debra Dalgleish has instructions for this at her site.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

 

[T. Valko]

See if this helps:

http://contextures.com/xlDataVal13.html

Biff

 

[Guest]

Hi,

Try this by using a sheet helper:

add a sheet to your workbook and enter you choice data like below:

A
1 machine brand
2 machine type
3 machine size
4 machine spacing
5 machine platen size
6
7 aaaaaaa
8 bbbbbbb
9 ccccccc
10
11 ddddddd
12 eeeeeee
13
14 ggggggg
15 hhhhhhh
16 kkkkkkk
17 mmmmmmm
18
19 nnnnnnn
20 ooooooo
21 ppppppp
22
23 qqqqqqq
24 sssssss

name range A1:A5 for example "machine"
in this example it asumed that the range A7:A9 is options for the first
categury (A1) and range A11:A12 is options for second categury (A2) and so on
name these ranges exactly to thier appropriate categury for example name
range A7:A9 to "machine brand" . . .
now go to the sheet that you want to place data validation for the first
column ( gateguies) active the range you want and go to: Data>Data
Validation>List and in the source text box enter: =machine
for the second column select the first top cell and go to: Data>Data
Validation>List and in the source text box enter: =indirect(A1) it is assumed
that your first column is A and started from the first row and you second
column is B and started from first column
after this you can copy formatting of the cell B1 to the cells below B2,B3,.
.. .
this is my underestanding of your issue try it may be it will work for you

Thanks,

 

[Guest]

Hi,

Excel -- Data Validation -- Create Dependent Lists.

Use this URL: http://www.contextures.com/xlDataVal02.html

Challa Prabhu