Excel help

Mark M · 6 Nov 2007 at 11:37

I have a workbook with 52 weekly sheets in it. I need to summarise the figures from each sheet onto one. Each week I need to pick up a total from, say, C30 (which never changes on each sheet. Is there a quick way of doing this?

Thanks for any help, Mark

TriedandTested · 6 Nov 2007 at 11:38

Yes, you can create formulas across worksheets, if that's what you mean?

Gaz1988 · 6 Nov 2007 at 11:49

example:

On sheet three somewhere...

=sum(Sheet1!A1+Sheet2!A1)

Mark M · 6 Nov 2007 at 11:49

Yeah but I dont want to have to type out each formula 52 times. Was just wondering if there was a quick way of doing it?

MarcLister · 6 Nov 2007 at 12:08

Select all 52 sheets then on the first one select the cell you want the formula in and type it out. Having selected the other sheets means this should copy the formula to the corresponding cell on the other 51 sheets.

When you've done this, select any of the other sheets to "lose" the hold Excel has on all 52 sheets and you should see the sheet you randomly selected has the formula there.