+ Reply to Thread
Results 1 to 2 of 2

Easiest way to copy the same formula with same data source to a different sheet

  1. #1
    Registered User
    Join Date
    03-10-2016
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Ms Excel 2013
    Posts
    1

    Easiest way to copy the same formula with same data source to a different sheet

    Hi, I need help,

    So I put a range of data in a sheet in excel, and I made a calculation of that data in that sheet.
    So I do everything in that sheet (let me just call it sheet1), now I want to move the calculation to a different sheet, so sheet1 only contain raw data.
    Is it possible to copy the exact calculation from sheet1 to another sheet? without redoing the calculation all over again?
    What I understand is to copy the formula exactly the same, but then I'll have to add something like "sheet1!" to each cell,

    Can anyone help me?
    Thank you

  2. #2
    Valued Forum Contributor
    Join Date
    01-03-2016
    Location
    Conwy, Wales
    MS-Off Ver
    2016
    Posts
    974

    Re: Easiest way to copy the same formula with same data source to a different sheet

    RIGHT CLICK on cell in sheet1
    select "CUT"
    click on Sheet2
    RIGHT CLICK on cell in sheet2
    select "PASTE"

    Look at the contents of the cell - formula should refer to values in sheet1

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 07-21-2015, 10:26 PM
  2. copy data from one sheet to annother, format it; Update to refect changes on source sheet
    By simplificated in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-13-2013, 03:45 PM
  3. how to copy (source sheet) a sheet going to another sheet (destination)
    By gerard_gonzales33 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-28-2012, 04:54 AM
  4. Replies: 1
    Last Post: 02-28-2012, 01:35 AM
  5. Replies: 1
    Last Post: 02-25-2012, 09:16 AM
  6. Easiest way to Copy/Paste data from Recurring Form to an Historical Data Sheet
    By willy91785 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-15-2010, 02:11 PM
  7. How to copy a sheet and rename it with the value of two cells from the source sheet?
    By Simon Lloyd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-11-2006, 08:31 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1