Help in Excel Please

[Sadric Amber]

Ok here's the deal (please bare with me):

I have a workbook that is 52 sheets long. Each sheet represents weeks 1 to 52. There is a block in each sheet that needs to feed off the prior sheets same block but add 1 to it. What is the formula to do this AND how do I copy this to all 52 sheets in one fell swoop? The block represents the week number, so on spreadsheet 2, the formula should reference week one and add one. On spreadsheet 3, the block should reference spreadsheet 2 and add one. Is there any way to do this?

Please Help!

Thanks

Sadric

[imaeditedbysowulo]

Not sure if this will allow you to do all sheets at one time, but here's how you do it.

Enter your beginning value on sheet 1. In the cell on the next sheet click the equals sign and then type an opening parenthesis (. Click on Sheet1 at the bottom of your workbook and you should see SHEET1! pop into your cell. Then just add the cell location + 1.

I tested it out on 3 sheets and it worked ok, here's what your cell content should look like for sheet 2:

=(Sheet1!A1+1)

Then sheet 3 should be:

=(Sheet2!A1+1)