If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|