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