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?


--
ATK
------------------------------------------------------------------------
ATK's Profile: http://www.excelforum.com/member.php...o&userid=27662
View this thread: http://www.excelforum.com/showthread...hreadid=472728

Have you looked at the INDIRECT worksheet function?


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=472728

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" wrote in message
...

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