View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Pull list / dropdown data from another worksheet?

I think if you name the range to be indexed, then reference the named
range in the seperate worksheet where you are creating the dropdown.