Coping a Formula to Workbook spreadsheets keeping formula in each spreadsheet.

[Quincey]

I trying to set up a yearly workbook, with 12 spreadsheets, one for each month. I have figures in cell b3, which I want to use on MTH2 to added to make a running total for the year on the same sheet, "sheet1!b3+ B2".

However, where I'm stuck is I now what to copy that same formula to the next month (MTH3) but I want the Formula to look at the figures in the second month (MTH2). If I just copy this formula, it loks to sheet1 instead of sheet2.

this there a way of coping this formula to next sheet telling it to look the next sheets before it in the workbook or do I have to just retype each one?

[popipipo]

Please Login or Register  to view this content.

This formula give as result the sheet naam: here for instance: sheet!2

Please Login or Register  to view this content.

sheet!2-1=sheet!1

[Quincey]

Thanks, I'll try that at work today