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