Tabs with different names

  • Thread starter Thread starter Rrsc
  • Start date Start date
R

Rrsc

Hi,
I have a worksheet with one tab for each day of the month (lets call it
december). All tabs have the same template. I created another worksheet that
collects and organize some of the data from "december", as a report would.

Does anyone know how can I choose the day from "december" which the report
will show? I would like to use buttons, in the report worksheet, to change
the day it is reporting. In the december worksheet, tabs names are like:
12-01, 12-02 and so on.

Thanks in advance!

Rodrigo
 
With 12 in cell A1, and 2 in cell B1, and the string D4 in cell C1, you could use the formula

=INDIRECT("'" & $A$1 &"-" & TEXT($B$1,"00") & "'!" & C1)


Or, this, if you want to incorporate the cell address:

=INDIRECT("'" & $A$1 &"-" & TEXT($B$1,"00") & "'!D4")

HTH,
Bernie
MS Excel MVP
 
Back
Top