Dropdown list

  • Thread starter Thread starter kraasty
  • Start date Start date
K

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
 
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.
 
No, that is the way.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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.
 
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
 
Back
Top