Drop Down List

[Guest]

How do I set up a drop list, when my list is on another worksheet within my
workbook?

 

[JE McGimpsey]

Name the list, say, "my_list", and use the name in the Validation
dropdown:

=my_list

 

[JulieD]

following on from John's answer -

to name a list, select your list and then click in the name box (left of the
formula bar, above column A) type a name (no spaces, can use underlines,
start with an alpha character) and press ENTER (doesn't work if you don't
press enter).

you might also like to check out Debra Dalgleish's website on Data
Validation for ideas on what you can do with data validation and dynamic
range names (i.e. so if you add new items to the named list, the range name
grows to accommodate them)
www.contextures.com/tiptech.html

Cheers
JulieD