I'm asking for example data along with a description of the way you want the lists to be dependent.Originally Posted by djd79
Aladin,
I'm not sure what you are asking here.
Daniel
I'm asking for example data along with a description of the way you want the lists to be dependent.Originally Posted by djd79
I was wondering if it is possible for the indirect function as described above to work for dynamic ranges. I have tried it but the pull down in the second column does work. If I make the range a fixed range it works, however I would really like to have the dynamic range.
Mark
See for an approach:Originally Posted by Mark_G
http://www.mrexcel.com/board2/viewto...set+validation
Indirect function together with several dropdown menus with data - validation <<<---- Is this possible? Ive got two dropdown menus and they are working like a charm. However, i want to have 3 or 4 dropwdown menus and depending of which choice i choose from the first 2-3 i will get some new choices from in the 4th dropdown menu.. Ive tried tha indirect function but i can only get this working together with 2 dropdowns..
Eric
Yes. Check out Juan's contrib here ... http://www.vbaexpress.com/forum/showthread.php?t=1072
I also have a workbook example with this in place already. If you'd like a copy, pm me with your email addy.
Regards,
Zack Barresse
My Book on Excel Tables
(If you would like comments in any code, please say so.)
As long as you define the sublists as referring to definite ranges (thus, not using formulas with OFFSET, INDEX...), INDIRECT() will suffice to construct cascading or dependent lists...Originally Posted by zanoman
******** ******************** ************************************************************************>
Microsoft Excel - aaCascadingDataValidLists zanoman.xls ___Running: 11.0 : OS = Windows XP
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
B C D E F G 1 2 FRANCE COUNTRIES USA FRANCE 3 USA New York Paris 4 Nice FRANCE Pittsburgh Nice 5 6 NIC1 NewYork Paris 7 N1 PAR1 8 N2 PAR2 9 10 Pittsburgh Nice 11 P1 NIC1 12 P2 NIC2 13
Sheet1
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
COUNTRIES refer to:
=Sheet1!$D$3:$D$4
USA refers to:
=Sheet1!$F$3:$F$4
FRANCE refers to:
=Sheet1!$G$3:$G$5
NewYork (without space) refers to:
=Sheet1!$F$7:$F$8
Pittsburgh refers to:
=Sheet1!$F$11:$F$12
Paris refers to:
=Sheet1!$G$7:$G$8
Nice refers to:
=Sheet1!$G$11:$G$12
Data validation in B2...
Allow set to List, Source to:
COUNTRIES.
Data validation in B4...
Allow set to List, Source to:
=INDIRECT(B2)
Data validation in B6...
Allow is set to List, Source to:
=INDIRECT(SUBSTITUTE(B4," ",""))
How about dropdown menu with data validation and checkboxes? From a pulldown menu you are allowed to pick a checkbox containg "X" or a chackbox containing "V". As in ok (V) and not ok (X). Is this "doable"?
Eric
I tried the USA-FRANCE example...
It answered who to access Data Validation List from another sheet's data AND how to do a parent - child relationship.
SWEET! TTom
Yesterday gives us the tools today to create our tommorrow... tt
thanks for the info. but I'm have 4 columns of data validation. each one is dependent on the previous. And the issue is when any of the data values is duplicated, Excel doesn't handle this well with the formula I'm using with INDIRECT and MATCH.
Like this thread? Share it with others