Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return a list dependent upon the selection of a preceeding list
I am creating a form defined by Category, Item, and sub-item. I would like
to be able to select the category from a list. Then dependent upon that answer I would like to be able to select the appropriate item from that specific Category list and so on. How can I do this? -- Thank you kindly, Aja |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return a list dependent upon the selection of a preceeding list
See Debra Dalgleish's instructions for using Dependent Lists:
http://www.contextures.com/xlDataVal02.html Does that help? *********** Regards, Ron XL2002, WinXP "Aja K" wrote: I am creating a form defined by Category, Item, and sub-item. I would like to be able to select the category from a list. Then dependent upon that answer I would like to be able to select the appropriate item from that specific Category list and so on. How can I do this? -- Thank you kindly, Aja |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return a list dependent upon the selection of a preceeding list
http://www.contextures.com/xlDataVal02.html
-- Regards, Peo Sjoblom "Aja K" wrote in message ... I am creating a form defined by Category, Item, and sub-item. I would like to be able to select the category from a list. Then dependent upon that answer I would like to be able to select the appropriate item from that specific Category list and so on. How can I do this? -- Thank you kindly, Aja |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return a list dependent upon the selection of a preceeding lis
You rock Ron. This is what I was hunting for.
-- Thank you kindly, Aja "Ron Coderre" wrote: See Debra Dalgleish's instructions for using Dependent Lists: http://www.contextures.com/xlDataVal02.html Does that help? *********** Regards, Ron XL2002, WinXP "Aja K" wrote: I am creating a form defined by Category, Item, and sub-item. I would like to be able to select the category from a list. Then dependent upon that answer I would like to be able to select the appropriate item from that specific Category list and so on. How can I do this? -- Thank you kindly, Aja |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return a list dependent upon the selection of a preceeding list
Aja
Check out Debra Dalgleish's site for dependent lists using Data Validation drop-downs. http://www.contextures.on.ca/xlDataVal02.html Gord Dibben MS Excel MVP On Wed, 11 Apr 2007 10:26:01 -0700, Aja K wrote: I am creating a form defined by Category, Item, and sub-item. I would like to be able to select the category from a list. Then dependent upon that answer I would like to be able to select the appropriate item from that specific Category list and so on. How can I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lists dependent on preceding list selection | Excel Discussion (Misc queries) | |||
create 2nd list dependent on 1st list | Excel Worksheet Functions | |||
validation list--list depends on the selection of first list | New Users to Excel | |||
How do I create a dependent list, to a current list? | Excel Discussion (Misc queries) | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions |