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

--
alison mason