Thread: Drop Down list from a different worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default Drop Down list from a different worksheet
It can be done, as long as you name the range that contains the list or
items. There are instructions he

http://www.contextures.com/xlDataVal01.html

Boo wrote:
I want to have a drop down on a worksheet populate from another worksheet in
the same workbook. The Help instructions tell me that it can be down but
when I follow the instructions I get a message telling me it can't be done.
Very confusing. Does anyone know which is right?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply With QuoteReply With Quote