| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data validation list drop-down values based on prior selections
I'm trying to create a spreadsheet with multiple fields whose values are
limited by Excel data validation lists. Rather than simply listing each value in the source I'd like subsequent field validations to be limited based on the prior selections. In other words the fields are related so only combinations in the source table should be permitted. Below is a simplified example. MODEL SIZE COLOR A Sm Black A Med White B Sm Black B Sm Red B Med Blue B Lar Green For MODEL the user is presented with the 2 distinct values: A, B. If B is selected the user is presented with 3 distinct values for SIZE: Sm, Med, Lar. If Sm is selected the user is presented with 2 distinct values for COLOR: Black, Red. How can this be accomplished in Excel? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data validation list drop-down values based on prior selections
I think what you're looking for is Dependent dropdowns. Have a look here
for more information. http://www.contextures.com/xlDataVal13.html -- HTH, Barb Reinhardt If thiIs post was helpful to you, please click YES below. "David" wrote: I'm trying to create a spreadsheet with multiple fields whose values are limited by Excel data validation lists. Rather than simply listing each value in the source I'd like subsequent field validations to be limited based on the prior selections. In other words the fields are related so only combinations in the source table should be permitted. Below is a simplified example. MODEL SIZE COLOR A Sm Black A Med White B Sm Black B Sm Red B Med Blue B Lar Green For MODEL the user is presented with the 2 distinct values: A, B. If B is selected the user is presented with 3 distinct values for SIZE: Sm, Med, Lar. If Sm is selected the user is presented with 2 distinct values for COLOR: Black, Red. How can this be accomplished in Excel? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data validation list drop-down values based on prior selection
I think that'll do it. Thanks!
"Barb Reinhardt" wrote: I think what you're looking for is Dependent dropdowns. Have a look here for more information. http://www.contextures.com/xlDataVal13.html -- HTH, Barb Reinhardt If thiIs post was helpful to you, please click YES below. "David" wrote: I'm trying to create a spreadsheet with multiple fields whose values are limited by Excel data validation lists. Rather than simply listing each value in the source I'd like subsequent field validations to be limited based on the prior selections. In other words the fields are related so only combinations in the source table should be permitted. Below is a simplified example. MODEL SIZE COLOR A Sm Black A Med White B Sm Black B Sm Red B Med Blue B Lar Green For MODEL the user is presented with the 2 distinct values: A, B. If B is selected the user is presented with 3 distinct values for SIZE: Sm, Med, Lar. If Sm is selected the user is presented with 2 distinct values for COLOR: Black, Red. How can this be accomplished in Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation List - Dependant based on numeric values | Excel Discussion (Misc queries) | |||
| Drop down list selections creating values in adjoining cell | Excel Worksheet Functions | |||
| How do I create 3 list boxes dependent on prior selections | Excel Discussion (Misc queries) | |||
| Can we change font size of values in validation drop down list? | Excel Discussion (Misc queries) | |||
| How do I use drop down list selections/values in a vlook up formu. | Excel Discussion (Misc queries) | |||
Linear Mode
