Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dependent Validation
I have seen solutions for dependent validation, but they are for pretty
simple situations. I have a need for four levels of validation (Pick Level 1, Options for level 2 are based on level 1, Options for level 3 are based on levels 1 and 2,....). The source file with all the options has about 1000 lines of data. Is there a way to do these searchs on the fly? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dependent Validation
Paul;228589 Wrote: I have seen solutions for dependent validation, but they are for pretty simple situations. I have a need for four levels of validation (Pick Level 1, Options for level 2 are based on level 1, Options for level 3 are based on levels 1 and 2,....). The source file with all the options has about 1000 lines of data. Is there a way to do these searchs on the fly? Here's a link to a workbook I created for someone to show how to flow several dependent lists in a row. This book goes three levels deep with many choices. You can easily extend that idea further. 'Excel Help Forum' (http://tinyurl.com/cvsukj) These dependent lists are based on named ranges. In my sample, if you highlight the cells below a colored title (like B2:B4) and then look at the name box to the left of the formula bar, you will see the names I gave them. The dependent lists are just lists of Named ranges, and the samples in column I and J use an INDIRECT() method in the cell's validation list to grab the name of the cell to the left to choose the next named range. Have a look. .. -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=63730 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dependent Validation | Excel Worksheet Functions | |||
Dependent Validation | Excel Worksheet Functions | |||
Dependent DropLists - Using Validation | Excel Worksheet Functions | |||
Validation of cells who is dependent on each other | Excel Discussion (Misc queries) | |||
Dependent List- Data Validation | Excel Worksheet Functions |