Dropdown list

[kraasty]

When I set "data validation" for a cell to "list" it only allows me
to use cells from the same worksheet.
How can I create a dropdown list with a range of cells located
in a different worksheet?

Thank you

Andreas

 

[JE McGimpsey]

name the list (select it and enter a name, say "mylist", without quotes,
in the Name Box at the left of the formula bar). Then in the Validation
dialog, enter

=mylist

as the list.

 

[kraasty]

I just find that I can use a named range instead,
Is there any other way to do this?

 

[Bob Phillips]

No, that is the way.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Ken Wright]

Nope - Also note that if you use a named range for this, and that range contains
any blank cells then the user can enter any value they like regardless of what
is on your list.

 

[JulieD]

Hi

untick "ignore blank" to stop this behaviour

Cheers
JulieD

 

[kraasty]

Thank you all for your replies.

I used a named range and unticked the "ignore blanks" (thank
you for the suggestion -I didn't forsee it)

Happy holidays,

Andreas