sub-drop down list

[phoenix911]

Hi

I have been trying to add a sub-dropdown list on my sheet and am having some difficulty doing this...

eg. column a; you get a drop-down list with options apple,beta,charlie. if you select apple in the drop-down list in column a, the drop down list in column b only has to give you the options 1,2,3. if you select beta in the drop-down list in column a, the drop down list in column b has to give you the options 4,5,6.

this also has to be valid for each row, cause I enter each case I work with on a new row.

thank you in advance,

 

[erik.van.geit]

Hi, phoenix911
Welcome to the Board !!!!!

this board has a "search"function: see link on top of the page
this will allow you to find useful tips in addition to what follows

take a look at this "famous" thread
(the link is already pointed to the "most relevant post")

http://www.mrexcel.com/board2/viewt...=0&postorder=asc&highlight=cascading&start=26

for a technique using comboboxes
http://www.mrexcel.com/board2/viewtopic.php?t=152281&start=5

see also this explanation
http://www.contextures.com/xlDataVal02.html

and
http://www.mrexcel.com/board2/viewtopic.php?t=15030&highlight=
feel free to send an email (no PM)
you'll get three files with examples

subject of email
cascading comboboxes

kind regards,
Erik

 

[phoenix911]

Awesome!! Thank you so much Erik.

I will get to know how this forum works and I'm further very sure that I will get (and hopefully in a small way) be able to add value to these forums.

Thnx again!