Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to select named range list dependent on another selection
I want to offer a named range list based on a selection from another list.
ie if a1 selection from named range "typesofpet" is "dog" then a2 named range list = listofdogs elseif selection from named range "typesofpets" = to "cat" then a2 named range is = "listofcats" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to select named range list dependent on another selection
You can use conditional validation pull-downs
http://www.contextures.com/xlDataVal02.html -- Gary''s Student - gsnu200733 "Matt Brown" wrote: I want to offer a named range list based on a selection from another list. ie if a1 selection from named range "typesofpet" is "dog" then a2 named range list = listofdogs elseif selection from named range "typesofpets" = to "cat" then a2 named range is = "listofcats" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to select named range list dependent on another selection
For a great tutorial goto:
http://www.contextures.com/xlDataVal02.html Hope this helps.. "Matt Brown" wrote: I want to offer a named range list based on a selection from another list. ie if a1 selection from named range "typesofpet" is "dog" then a2 named range list = listofdogs elseif selection from named range "typesofpets" = to "cat" then a2 named range is = "listofcats" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ignore blank cells in a named range when using dependent data validation | Excel Discussion (Misc queries) | |||
Return a list dependent upon the selection of a preceeding list | Excel Worksheet Functions | |||
Create a drop down list dependent on selection from another list | Excel Programming | |||
Multi select dependent on cell in range | Excel Programming | |||
lists dependent on preceding list selection | Excel Discussion (Misc queries) |