| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can data validation ranges be linked to a referenced cell?
Trying to set a selection sheet that contains pick lists based on prior
input. For instance, first pick list would be make of car (Honda Picked), second pick list would be model of car (Accord, Pilot, Civic, etc). The second pick list would only identify options available based on the first answer. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can data validation ranges be linked to a referenced cell?
See Debra Dalgleish's site for "dependent DV lists"
http://www.contextures.on.ca/xlDataVal02.html Gord Dibben MS Excel MVP On Thu, 4 Sep 2008 19:07:00 -0700, McSorley wrote: Trying to set a selection sheet that contains pick lists based on prior input. For instance, first pick list would be make of car (Honda Picked), second pick list would be model of car (Accord, Pilot, Civic, etc). The second pick list would only identify options available based on the first answer. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using the address referenced in a linked cells | Excel Worksheet Functions | |||
| Data Validation with linked File | Excel Discussion (Misc queries) | |||
| Linked Data Validation(s) | Excel Programming | |||
| SUMIF ranges linked to a data validation cell | Excel Discussion (Misc queries) | |||
| Data Validation linked to cell Formula | Excel Discussion (Misc queries) | |||
Linear Mode
