Linked Drop Down Lists

[nicolai185]

Hello!
I am attempting to create multiple drop down lists where the second box is dependent on the values entered into the first. I know this has been done before, but this may be somewhat unique.

Essentially, I want users to select a value from the first list (in this case, teacher name) and I want the second list to populate a list of just their students (not the whole school). There are 100 teachers and I want to figure out a way that I can use vlookup to reference the first list and populate a named range that i can reference for the second list.

I would prefer not to use a macro if possible, but I'm not super familiar with them. This document will need to be emailed to various teachers who have Excel 2007 and a few with macs.

Any help would be GREAT! Thanks

Nick

 

[SteveO59L]

Have a look at Aladin's classic solution, here

http://www.mrexcel.com/forum/showthread.php?p=126

 

[nicolai185]

I'm familiar with this solution. I do not want to predefine each list though, because I would have over 100 separate lists with 100 students in each list.

 

[nicolai185]

I have solved it thanks to jimbojr from this post:

http://www.mrexcel.com/forum/showthread.php?t=82692

and some minor modifications.