Drop Down Menus
 

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

Drop Down Menus
 

See:

http://www.contextures.com/xlDataVal02.html
--
Gary''s Student - gsnu200843


"Alison Mason" wrote:

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