View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
angelila
 
Posts: n/a
Default Obtain data from various sheets?

I would like to be able to call out data from various sheets with out naming
the sheet in the formula. I would like to be able to input the name of the
sheet into a cell and then the formula would use the name of the sheet from
that cell to lookup the data. I think it should be some type of "lookup"
formula but I can't figure it out.