Excel equations

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?

Have you looked at the INDIRECT worksheet function?

ATK wrote:
> 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

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!
==============================================



"ATK" <ATK.1wcbea_1128366319.4137@excelforum-nospam.com> wrote in message
news:ATK.1wcbea_1128366319.4137@excelforum-nospam.com...
>
> 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?
>
>
> --
> ATK
> ------------------------------------------------------------------------
> ATK's Profile:
http://www.excelforum.com/member.php...o&userid=27662
> View this thread: http://www.excelforum.com/showthread...hreadid=472728
>