Copying formula changing references
Hi everyone,
I dont know if it is possible or if the question makes sense but here it goes.
Lets assume i have a column/line with the following values/formulas
E
8 ='1'!L15+'1'!L138
9 ='2'!L15+'2'!L138
10 ='3'!L15+'3'!L138
As you can see im catching those references from different sheets
Now what i want is copy those formulas to the next column (F) but changing the references for the following:
F
8 ='1'!O15+'1'!O138
9 ='2'!O15+'2'!O138
10 ='3'!O15+'3'!O138
Does it make sense? Is it possible without have to go to each cell changing the references manually? As you can see i only changed the reference from L to O. The rest maintains the same.
Thank you
|