tab references in formulas

  • Thread starter Thread starter kspear
  • Start date Start date
K

kspear

I have a wookbook that has a tab i'll call "summary" with several tab
that have specific data. The summary tab will reference those dat
tabs nad do calcs in the summary tab. Here's the glitch, there is
column in the summary tab that specifies which tab to use for that row


SO, the formulas in that row should then use the value in the "ta
name" column in the respective formulas.

I need this functionality as the rows use different tabs depending o
the circumstance. Instead of always rewriting the formulas, i wa
hoping I could change the tab name reference in 1 column and have i
adjust the cell formulas accordingly.

Any ideas?

Kevi
 
Hi

With sheet name p.e. in cell A2, something like this:
=SUM(INDIRECT(A2 & "!C2:C100"))
when sheet name doesn't contain blanks. Or
=SUM("'" & INDIRECT(A2 & "'!C2:C100"))
when there are blanks in sheet name.
 
Back
Top