Carrying formulas forward from Worksheet to Worksheet

M

mrudnet

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.
 
T

T. Valko

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Carrying formulas from one sheet to the next within the same file 2
Indexing a formula from Sheet to Sheet 3
how to carry forward a total from one page to another 3
formula problem in grouped worksheets 1
Copy worksheet to new doc w/formulas not referencing previous doc 4
Deleting worksheet breaks my formulas 3
emailing worksheet... 1
Is there a Formula that would help me? 3

Top