Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use condiational validation choices in same column? | Excel Worksheet Functions | |||
validation - anyway to select multiple choices in the pull down? | Excel Worksheet Functions | |||
Choices from Data Validation List | Excel Discussion (Misc queries) | |||
Choices for User | Excel Worksheet Functions | |||
Choices | Excel Worksheet Functions |