View Single Post
  #1  
Old November 17th, 2003, 09:16 PM
Peo Sjoblom
external usenet poster
 
Posts: n/a
Default Sheet copy with absolute reverence

Just do an editreplace 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" wrote in message
...
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.