View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CBZ[_2_] CBZ[_2_] is offline
external usenet poster
 
Posts: 10
Default Is there an such a function?

Just wondering is there such a function that would allow me to present
separate drop down pick lists dependent upon reference cell content.

ie. if cell b2="queue" then list for pick cells A1:A10 or if cell
b2="queue1" then list alternative list for pick b1:b10?

As always I appreciate the help or ref. to another function that may assist
me?