Forum Discussion
Excel Double list please help
Hi,
I created a list in cell B8 and depending on the choise made i want a set of choises in C8,
For example:
Now i have selected "schilderwerk buiten" depending on this choise i want different choises in C8
For exemple: a teacher grades his test from 0 to 10 and 0 to 5, if he decide to go for 0 to 10 he wants al number between 0 and 10, but only 0 to 5 if he decide to grade it from 0 to 5.
I someone can help me out they would be a hero for life, i have been searching everywhere without finding anything.
With Isolatie I want the 5 option that stand after isolatie.
Let me know if you manage to fix my problem.
Remco
10 Replies
See the attached workbook. I used a combination of data validation and named ranges.
See Create Dependent Drop Down Lists for background information.
- HansVogelaar It works, thank you very much.
I don't know i you also know how this works but for the option i selected there is a fixed data which can be automaticly filled inWould you like the first option to be filled in in column C?
(Je kan in het Nederlands antwoorden als je dat makkelijker vindt)
Remco_Verduin Search on-line for "Dependent dropdown" and you'll find plenty options to choose from. It depends on your Excel version which one to use.
- Riny_van_Eekelen Thanks it is working like I wanted to now.
