Sheet copy with absolute reverence

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to copy a sheet with many formulas that reference sheet one. I want to copy sheet 2 to sheet 3, but I want the formulas to reference sheet 2 not one. When I copy, all the sheet references stay sheet 1. I want them to progress, so sheet 3 referes to 2, 4 referes to 3 etc. I have to have 25 sheet s in this manor, all in the same workbook. Any Ideas
Thanks.
 
Just do an edit>replace and replace Sheet1 with Sheet2

Another way would be to use a reference to the sheet in the formula

=A2*INDIRECT("'Sheet"&RIGHT(CELL("filename",A1))-1&"'!A6")

copied over from Sheet2 referencing Sheet1 will change to Sheet2
Don't change this part in the formula RIGHT(CELL("filename",A1))-1
That means that your sheet names have to use the same name plus a number



--

Regards,

Peo Sjoblom


Rob said:
I am trying to copy a sheet with many formulas that reference sheet one.
Click to expand...
I want to copy sheet 2 to sheet 3, but I want the formulas to reference
sheet 2 not one. When I copy, all the sheet references stay sheet 1. I
want them to progress, so sheet 3 referes to 2, 4 referes to 3 etc. I have
to have 25 sheet s in this manor, all in the same workbook. Any Ideas?
 
Back
Top