Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-26-2019, 03:17 AM
xor xor is offline cut and paste cells with fomulas from a worksheet to another one Windows 10 cut and paste cells with fomulas from a worksheet to another one Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,103
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Can't you just make formulas in Sheet2 like:

=Sheet1!A4+Sheet1!C4 and copy down?
Reply With Quote
  #2  
Old 01-26-2019, 03:38 AM
dogufo dogufo is offline cut and paste cells with fomulas from a worksheet to another one Windows 7 64bit cut and paste cells with fomulas from a worksheet to another one Office 2013
Banned
cut and paste cells with fomulas from a worksheet to another one
 
Join Date: Sep 2018
Location: Usa
Posts: 11
dogufo is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
Can't you just make formulas in Sheet2 like:

=Sheet1!A4+Sheet1!C4 and copy down?
thanks for reply
I know that, ... this is just a simple example, but the real file I must work with has a lot of formulas to move in another sheet keeping in the formulas the cells of origin sheet; so I just asked if there was a fast way to do it witouht adding to the formula "Sheet1!"
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I copy a worksheet and paste values to another new workbook ? DBenz Excel 1 01-26-2019 07:03 AM
Looking to copy select cells in table using dropdown list to paste to new table in another worksheet CaptainRetired Excel Programming 18 01-04-2018 07:22 PM
cut and paste cells with fomulas from a worksheet to another one Get multiple cells in separate worksheet kerkstrt Excel 1 10-26-2014 11:20 PM
Can you copy & paste cells across worksheets and preserve reference to worksheet? New Daddy Excel 2 11-27-2013 07:19 AM
cut and paste cells with fomulas from a worksheet to another one Insert/Paste Picture into Protected Worksheet udea Excel 1 02-06-2012 07:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:06 AM.


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