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 |
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 |