Drop Down List
 

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

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

=my_list

In article ,
"jabernathy" wrote:

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

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

"JE McGimpsey" wrote in message
...
Name the list, say, "my_list", and use the name in the Validation
dropdown:

=my_list

In article ,
"jabernathy" wrote:

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