Thread: How can I create a drop down list from non-adjacent cells
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Cutter
 
Posts: n/a
Default How can I create a drop down list from non-adjacent cells

The simplest solution would be to have 2 out-of-sight cells linked to
your desired info.

ie. if you want A5 and A10 values in your list have formulas somewhere
out of the way linking to those 2 cells - say in Z1 you have =A5 and in
Z2 have =A10

Then use Z1:Z2 for your Data Validation list


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=505517

Reply With QuoteReply With Quote