Excel equations

[ATK]

I posted this before, but for some reason, it never showed up.

I want to be able to take a list of months in a spreadsheet and add
these months to an equation without having to type it out every time.
Let me explain:

I have a column of text ranging from January to Dec. I also have
worksheets titled from Jan to Dec. I need to reference various cells
in each of the spreadsheets in a summary spreadsheet, but each
reference cell is the same for each month, i.e. always January!$A$1,
February!$A$!, etc.

Is there a way I can write an equation that will allow be to copy the
months in the summary sheet and append the $A!1 into the text and get
it to return the value of the respective cells?

 

[MrShorty]

Have you looked at the INDIRECT worksheet function?

 

[Bill Martin]

I posted this before, but for some reason, it never showed up.

I want to be able to take a list of months in a spreadsheet and add
these months to an equation without having to type it out every time.
Let me explain:

I have a column of text ranging from January to Dec. I also have
worksheets titled from Jan to Dec. I need to reference various cells
in each of the spreadsheets in a summary spreadsheet, but each
reference cell is the same for each month, i.e. always January!$A$1,
February!$A$!, etc.

Is there a way I can write an equation that will allow be to copy the
months in the summary sheet and append the $A!1 into the text and get
it to return the value of the respective cells?

Use the INDIRECT() statement. The Excel Help system will explain it and provide
examples.

Bill

 

[RagDyer]

Say the summary sheet has the months entered in A1 to A12, spelled *exactly*
the same as the sheet tabs.

In B1, enter this formula:

=INDIRECT(A1&"!A1")

And copy down 12 rows.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================