#1




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 
#2




Copy cells with formula, and paste then into column which is 3rd one at right from original one  you must get the reference to column O in source sheets. Then select sells with copied formula, and drag the selection into next column at right from original column. Or simply delete empty columns between. (You must have enough empty columns to right from original column to start with.)

#3




thank you!

Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Need help with dragging a formula and changing a reference column as I drag the formula.  LupeB  Excel  1  10222015 03:02 PM 
Propagating a formula which references a named cell  Splint  Excel  4  06152015 04:55 AM 
Globally changing formatting of intext cross references  estube  Word  1  07082014 03:21 AM 
Changing text in crossreferences  Richard B  Word  3  09112013 07:18 AM 
Formula that references cell with text in different workbook  no1texan  Excel  3  07172012 05:58 AM 