Copying a formula to multiple worksheets

G

Guest

Is there a way to copy a formula to multiple worksheets so that Excel
understands that you don't want to use the first worksheet formula, but the
formula on the preceding worksheet?

Example:

52 sheets (one for each week)
Cell A1 Worksheet 1 = Jan 7 (first week ending date)
Cell A1 Worksheet 2 = =+Sheet1!A1+7, giving Jan 14
If I copy Cell A1 Worksheet 2 to Cell A1 Worksheet 3, I get Jan 14; I want
Jan 21

I want Excel to consider that I'm copying a formula that references a cell
on the previous sheet, so the result should reference the previous sheet, not
the first sheet

Anyone know how to make it work?
 

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

Totalling sequential worksheets 1
Linking to other worksheets 3
Inerting name of current worksheet into fuction 11
Copying Cell from Multiple Worksheets to a Summary Worksheet 4
Excel Count If Formula Question 1
INDIRECT reference to another worksheet in same workbook 4
How do i edit links automatically? 1
sum accross worksheets using names 1

Top