Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-06-2019, 06:00 AM
nmcbs84 nmcbs84 is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2019
Posts: 2
nmcbs84 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 02-06-2019, 07:51 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 424
ArviLaanemets will become famous soon enough
Default

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.)
Reply With Quote
  #3  
Old 02-06-2019, 08:11 AM
nmcbs84 nmcbs84 is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2019
Posts: 2
nmcbs84 is on a distinguished road
Default

thank you!
Reply With Quote
Reply

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


All times are GMT -7. The time now is 03:59 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft