#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 | 10-22-2015 03:02 PM |
Propagating a formula which references a named cell | Splint | Excel | 4 | 06-15-2015 04:55 AM |
Globally changing formatting of in-text cross references | estube | Word | 1 | 07-08-2014 03:21 AM |
Changing text in cross-references | Richard B | Word | 3 | 09-11-2013 07:18 AM |
Formula that references cell with text in different workbook | no1texan | Excel | 3 | 07-17-2012 05:58 AM |