djd79 said:Aladin,
I'm not sure what you are asking here.
Daniel
Mark_G said: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
zanoman said: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
aaCascadingDataValidLists zanoman.xls | ||||||||
---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | |||
1 | ||||||||
2 | FRANCE | COUNTRIES | USA | FRANCE | ||||
3 | USA | NewYork | 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 |