| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data validation dependencies
This is what I'm looking for. Thanks.
"Toppers" wrote: See: http://www.contextures.com/xlDataVal02.html "MLK" wrote: Is there a way to narrow down data value selections for users based on input criteria? What I would like to do is have users select a value from column A, but then in column B I want to narrow down their value list selection BASED on the value they selected in column A. For example, if users selected "Night" in column A, then I want "Bat", "Owl", "Kinkajou" to be the only available values in column B for users to select from. However, if they selected "Day" in Column A, then I want "Dog", "Cat", "Horse" to be the only available values in Column B for users to select from. The goal is to narrow their selections down (based on their earlier value selections) in order to avoid data entry mistakes. Thanks, Mary-Lou |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Lists Dependencies | New Users to Excel | |||
| No Record Source, no dependencies? | Charts and Charting in Excel | |||
| Data Validation - Multiple Dependencies | Excel Discussion (Misc queries) | |||
| Drop Down Menu - dependencies | Excel Discussion (Misc queries) | |||
| List Dependencies | Excel Discussion (Misc queries) | |||
Threaded Mode
