Drop Down Menus

[Alison Mason]

i would like to link column 1 (with drop down menu) to column 2 (with drop
down menu) so that if say I insert year 7 in colour 2 from the ddm then when
I select ddm in column 1 it will only bring up my data under year 7 and not
all three years that are stored in there.

Thanks

 

[Gary''s Student]

See:

http://www.contextures.com/xlDataVal02.html