imla
Member
I have a workbook that start with one sheet and grow every day (I use move and copy... to create a new copy of previous sheet) my question is:
in sheet(i) where i>1, I have a lot of formulat (~50) depend to sheet(i-1) so when I mad a copy of sheet(i) to generate sheet(i+1) what I whant is in sheet(i+1) all formula will be auto updated to refference sheet(i) not sheet(i-1) without breking the formult or using custom user function or macro or any sort of INDIRECT...etc.
for example: in sheet(3) cell B2 I have a formulat = sheet(2)'!$A1-$A1
if from sheet(3) I create the sheet(4) I want the formulat in cell B2 to be = sheet(3)'!$A1-$A1.
I think that there is a methos that I can use do that!?
link of sample file :
http://www.mediafire.com/?t3bx6k1ccb8uaw5
in sheet(i) where i>1, I have a lot of formulat (~50) depend to sheet(i-1) so when I mad a copy of sheet(i) to generate sheet(i+1) what I whant is in sheet(i+1) all formula will be auto updated to refference sheet(i) not sheet(i-1) without breking the formult or using custom user function or macro or any sort of INDIRECT...etc.
for example: in sheet(3) cell B2 I have a formulat = sheet(2)'!$A1-$A1
if from sheet(3) I create the sheet(4) I want the formulat in cell B2 to be = sheet(3)'!$A1-$A1.
I think that there is a methos that I can use do that!?
link of sample file :
http://www.mediafire.com/?t3bx6k1ccb8uaw5