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.
|