Formula on sheet2 references sheet1 in same workbook

[asotmhg]

Lets say that I have data in Cell A1 through A12. In cell B1 I put the following formula: =A1+1 When I copy that formula down to B2 through B12 the basics of the formula stays the same except A1 will be substituted with A2 through A12: =A2+1
=A3+1 etc....

On another worksheet in the same workbook I reference the first worksheet's B column with the following formulas in A1 through A12:

=sheet1!B1
=sheet1!B2 etc...

This will go on for several worksheets in the same workbook with column A referencing the values in column B from the previous worksheet. How can I get the formulas to reference the previous worksheet without hand typing the formula on each worksheet? sheet2 references sheet1, sheet3 references sheet2, sheet4 references sheet3, etc...

 

[sawedoff]

If you don't already have all the sheets set up, set sheet one, then set up sheet 2 using a VBA function as referenced in

http://www.j-walk.com/ss/excel/tips/tip63.htm.

Then after you have sheet 2 working, use Edit- Move or copy sheet to create the remaining sheets. Just be sure to check the Create a copy checkbox.

Sawedoff

 

[dhulbert]

Once you've got sheet2 set up mae a copy of it then just do a find-replace to shange the formulae from Sheet1 to sheet2
then just keep going for however many sheets you need it for.