If I have 52 tabs in one Excel file (one for each week of the year) and I
want to copy and paste the formula from Tab 1 to Tab 2 and so on, how do I
get the formulas to copy forward if I need a cumulative total from for
example Tab 1 plus Tab 2 to give me the total and then it would continue with
the total on Tab 2 plus Tab 3 to give me a new total and on it goes. Does
anyone know? THanks.

Need more detail. Do your tab names follow some sort of sequence like WK1,
WK2, WK3....WK52 ? Do you want the cumulative total of the same cell on
every sheet? For example:

WK1 A1 = 50
WK2 A1 = 25 ... some cell in WK2 = 75
WK3 A1 = 10 ... some cell in WK3 = 85
WK4 A1 = 15 ... some cell in WK4 = 100

Is that what you're wanting to do?



--
Biff
Microsoft Excel MVP


"mrudnet" wrote in message
...
If I have 52 tabs in one Excel file (one for each week of the year) and I
want to copy and paste the formula from Tab 1 to Tab 2 and so on, how do I
get the formulas to copy forward if I need a cumulative total from for
example Tab 1 plus Tab 2 to give me the total and then it would continue
with
the total on Tab 2 plus Tab 3 to give me a new total and on it goes. Does
anyone know? THanks.