Validation - Narrowing down choices
 

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

Validation - Narrowing down choices
 

Jamie

Debra Dalgleish has instructions for this at her site.

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


Gord Dibben MS Excel MVP

On Fri, 30 Mar 2007 12:48:04 -0700, Jamie
wrote:

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

Validation - Narrowing down choices
 

See if this helps:

http://contextures.com/xlDataVal13.html

Biff

"Jamie" wrote in message
...
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

Validation - Narrowing down choices
 

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: DataData
ValidationList and in the source text box enter: =machine
for the second column select the first top cell and go to: DataData
ValidationList 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,
--
Farhad Hodjat


"Jamie" wrote:

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

Validation - Narrowing down choices
 

Hi,

Excel -- Data Validation -- Create Dependent Lists.

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

Challa Prabhu


"Jamie" wrote:

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