Thread: drop down list location
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default drop down list location
You can use a list on a different sheet in the workbook, if you name the
range of cells that contains the list.

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


nowhereman wrote:
can the data for a drop down list be on another sheet in the workbook or
even in another workbook .... If possible what is the process

TIA


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply With QuoteReply With Quote