Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation selection
Having read the following posts - I thought it would be easy to have 5
categories with up to 30 items in each sub category. Please help... the first column and categories work fine, but the sub-set does not. Some rows do not display a menu and if they do they are not the corresponding items. I have changed names etc to no avail. I cannot see what I am doing wrong.... "I think Dependent Lists will meet your requirements. See Debra Dalgleish's website for instructions: http://www.contextures.com/xlDataVal02.html Does that help? *********** Regards, Ron XL2002, WinXP "scott56hannah" wrote: I want to be able to drive the selection by Data Validation Lists from the selection of one list - eg category.....following selection of an item in that list.....the secondary list is populated with valid sub-categories only for that category.....is there anyway to do this using validation lists or is another approach needed ?" |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation selection
I don't think we will be able to guess what you did, the permutations are
enormous. What exactly did you do, what formulae, data etc.? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "premierbmwagve" wrote in message ... Having read the following posts - I thought it would be easy to have 5 categories with up to 30 items in each sub category. Please help... the first column and categories work fine, but the sub-set does not. Some rows do not display a menu and if they do they are not the corresponding items. I have changed names etc to no avail. I cannot see what I am doing wrong.... "I think Dependent Lists will meet your requirements. See Debra Dalgleish's website for instructions: http://www.contextures.com/xlDataVal02.html Does that help? *********** Regards, Ron XL2002, WinXP "scott56hannah" wrote: I want to be able to drive the selection by Data Validation Lists from the selection of one list - eg category.....following selection of an item in that list.....the secondary list is populated with valid sub-categories only for that category.....is there anyway to do this using validation lists or is another approach needed ?" |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation selection
I think you'll need to describe the ranges you're using, the formulas in the
Data Validation, and post some sample data for a more substantive answer. *********** Regards, Ron XL2002, WinXP "premierbmwagve" wrote: Having read the following posts - I thought it would be easy to have 5 categories with up to 30 items in each sub category. Please help... the first column and categories work fine, but the sub-set does not. Some rows do not display a menu and if they do they are not the corresponding items. I have changed names etc to no avail. I cannot see what I am doing wrong.... "I think Dependent Lists will meet your requirements. See Debra Dalgleish's website for instructions: http://www.contextures.com/xlDataVal02.html Does that help? *********** Regards, Ron XL2002, WinXP "scott56hannah" wrote: I want to be able to drive the selection by Data Validation Lists from the selection of one list - eg category.....following selection of an item in that list.....the secondary list is populated with valid sub-categories only for that category.....is there anyway to do this using validation lists or is another approach needed ?" |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation selection
Hi Bob
Situation resolved it all works properly when I realised that there were hidden rows and columns which i was referencing... Many Thanks. "Bob Phillips" wrote: I don't think we will be able to guess what you did, the permutations are enormous. What exactly did you do, what formulae, data etc.? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "premierbmwagve" wrote in message ... Having read the following posts - I thought it would be easy to have 5 categories with up to 30 items in each sub category. Please help... the first column and categories work fine, but the sub-set does not. Some rows do not display a menu and if they do they are not the corresponding items. I have changed names etc to no avail. I cannot see what I am doing wrong.... "I think Dependent Lists will meet your requirements. See Debra Dalgleish's website for instructions: http://www.contextures.com/xlDataVal02.html Does that help? *********** Regards, Ron XL2002, WinXP "scott56hannah" wrote: I want to be able to drive the selection by Data Validation Lists from the selection of one list - eg category.....following selection of an item in that list.....the secondary list is populated with valid sub-categories only for that category.....is there anyway to do this using validation lists or is another approach needed ?" |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation selection
Following Debra's instructions step by step will give you what you need.
You can drill down several levels using her methods. As far as what you are doing wrong...............difficult to see from here. How are you creating the lists? From a range or typing directly into the source dialog? How are you naming your lists? How do you enter the listnames into the source dialog? Must be preceded by an = sign like =MyList Gord Dibben MS Excel MVP On Tue, 2 Jan 2007 08:55:00 -0800, premierbmwagve wrote: Having read the following posts - I thought it would be easy to have 5 categories with up to 30 items in each sub category. Please help... the first column and categories work fine, but the sub-set does not. Some rows do not display a menu and if they do they are not the corresponding items. I have changed names etc to no avail. I cannot see what I am doing wrong.... "I think Dependent Lists will meet your requirements. See Debra Dalgleish's website for instructions: http://www.contextures.com/xlDataVal02.html Does that help? *********** Regards, Ron XL2002, WinXP "scott56hannah" wrote: I want to be able to drive the selection by Data Validation Lists from the selection of one list - eg category.....following selection of an item in that list.....the secondary list is populated with valid sub-categories only for that category.....is there anyway to do this using validation lists or is another approach needed ?" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
validation list - filter based on selection | Excel Worksheet Functions | |||
validation list--list depends on the selection of first list | New Users to Excel | |||
How can you jump to a selection in a validation drop-down? | Excel Worksheet Functions | |||
Data Validation Window? | Excel Discussion (Misc queries) | |||
Data Validation list selection question | Excel Worksheet Functions |