Create a formula referencing a sheet

  • Thread starter Thread starter lynxbci
  • Start date Start date
L

lynxbci

I have a workbook with a header sheet and 12 seperate sheets containing
data for months 1 to 12 (named jan,feb,mar etc)

I want to enter a month into a cell on the header sheet, and then all
formulas on that sheet to refer to that particular sheet and retrieve
data.

example

Header sheet has cell A1 and i have typed JUN in it

The cell B1 has =JUN!C20 and returns C20 from the june sheet

If I then type AUG in A1 how can i update the (=JUN!C20) to =AUG!C20
without retyping it for each of my 60 or so refernces.

Thanks
 
One way:

B1: =INDIRECT("'" & A1 & "'!C20")

lynxbci said:
I have a workbook with a header sheet and 12 seperate sheets containing
data for months 1 to 12 (named jan,feb,mar etc)

I want to enter a month into a cell on the header sheet, and then all
formulas on that sheet to refer to that particular sheet and retrieve
data.

example

Header sheet has cell A1 and i have typed JUN in it

The cell B1 has =JUN!C20 and returns C20 from the june sheet

If I then type AUG in A1 how can i update the (=JUN!C20) to =AUG!C20
without retyping it for each of my 60 or so refernces.

Thanks
Click to expand...
 
Back
Top