Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-06-2019, 06:00 AM
nmcbs84 nmcbs84 is offline Copying formula changing references Windows 10 Copying formula changing references Office 2016
Novice
Copying formula changing references
 
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 Copying formula changing references Windows 8 Copying formula changing references Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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 Copying formula changing references Windows 10 Copying formula changing references Office 2016
Novice
Copying formula changing references
 
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
Copying formula changing references Globally changing formatting of in-text cross references estube Word 1 07-08-2014 03:21 AM
Copying formula changing references 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:14 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft