tab references in formulas

[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

 

[Arvi Laanemets]

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.