software

I have a simple formula in one workbook adding two cells in another
workbook:
=[book1]Sheet1!$A$1 [book1]Sheet1!$A$2

Next month I want to refer to the same workbook, same sheet, but I want
all the rows to shift down by 26:
=[book1]Sheet1!$A$27 [book1]Sheet1!$A$28

There are about forty formulas so I don't want to go in there and
manually add 26 to every little reference every time. Ideas???
thanks---
Jean
------------------------------------------------------------------------
Jean's Profile: www.excelforum.com/member.php...oamp;userid=17585
View this thread: www.excelforum.com/showthread...hreadid=508575
Solved this problem myself----=OFFSET([book1]Sheet1!$A$1,month*26-26,0) OFFSET([book1]Sheet1!$A$2,month*26-26,0)

When I assign the month cell to 1 for January, I'll get A1 A2 then in
February month =2 so I'll have A27 A28Is there a better way?--
Jean
------------------------------------------------------------------------
Jean's Profile: www.excelforum.com/member.php...oamp;userid=17585
View this thread: www.excelforum.com/showthread...hreadid=508575