Drop down lists

[Katherine]

Can you help me - I am trying to make a drop down box -
where a user can select from a list of information what
will go in the box -- my list is in a sheet labeled
sheet and I labled the table in the name box
as "Standards" --- I went to my master data base
highlighted the row I want the drop down box to appear -
then I used the --- DATA - VALIDATION - LIST - and input
the name STANDARDS into the source box and clicked enter --
now instead of getting the list when I check the box --
I get the word STANDARDS in my drop down box - can you
help? Thank you

Katherine

 

[JulieD]

Hi Katherine

put a = in front of the word standards in the data validation box
better still, delete the word standards and press your F3 key, you can then
select standards from the range name box and this will put the = sign in for
you (when you press the OK button)

hope this helps
Cheers
JulieD

 

[JE McGimpsey]

use

=STANDARDS