Excel spreadsheet formulae

[kags]

Can you copy formulae relatively between worksheets in the same file? I have 12 worksheets, each with various monthly totals, and I also want running totals. These are very straightforward formulae, on page 2 I want to add that month's total to the total for month 1, then add that new total to month 3 on the next page, etc etc. I copied the formulae from month 2 to the other months, but it added each month to month 1 rather than the previous month. Within a worksheet this is easy, you just drag the little box in the corner of the cell. Obviously I could do them all manually, but I would be surprised if the normally very logical Excel didn't have a method of doing this.

[rinkytink]

Okay I think I have what you mean.
I have set up a spread sheet with three worksheets in it:

On sheet 1 cell A1 contains 1, cell B1 contains 2, and cell C1 has the formula =A1+B1 which = 3

On sheet 2 cell A1 contains 4, cell B1 contains 5 and cell C1 has the formula =A1+B1+Sheet1!C1 which = 12

On sheet 3 cell A1 contains 6, cell B1 contains 7 and cell C1 has the formula =A1+B1+Sheet2!C1 which = 25

So all you are doing is saying give me the total of whatever cells on this sheet plus the value that is contained in the total cell on the previous sheet.

So to get this to work for sheet 4 click on cell C1 in sheet 4 and put an = in, Click A1, then +, then click B1, then go to sheet three and click the total cell (C1), and the click the green tick.

Now having typed all this out I has just thought....this is what you mean by doing it manually!! So then the answer is no, you can't do an autofill across work sheets.

A short cut would be to do a fill across work sheets. Select the cell you want to copy and the select all the other work sheets you want to copy it to. Go to Edit...fill...across worksheets. This will copy the formula to each corresponding cell of all selected work sheets. You would then have to go to each cell and amend the formula to calculate the correct work sheet.

Hope this makes sense !!

[kags]

thank you for taking the time to answer rinkytink - I didn't know about "edit fill", which would be a great shortcut - and I'm glad I wasn't missing something blindingly obvious!!!