+ Reply to Thread
Results 1 to 2 of 2

Copy and Paste linked cells as value but keep the 'SUM' function formula

  1. #1
    Registered User
    Join Date
    04-20-2021
    Location
    Singapore
    MS-Off Ver
    Microsoft Office 2013
    Posts
    1

    Copy and Paste linked cells as value but keep the 'SUM' function formula

    Hi,

    I have two range of cells with values linked to another workbook. There are two 'SUM' formula at the end of each range of values. All these were presented in one column. Is there any way for me to copy the whole column and paste as values in another column but still keep the 'SUM" function. (instead of copying the linked cell, paste as values in another column and drag/type the 'SUM' function again at the new column)

    For e.g. Referring to the image below, I want to copy column B and paste as values in column C but still keep the 'SUM' function in row 15 and 20.

    Screenshot 2021-04-20 135804.jpg

    Thanks

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Copy and Paste linked cells as value but keep the 'SUM' function formula

    Short answer - no
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. What's faster? Formula's linked to external sheets or copy/paste via VBA?
    By anon in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-27-2019, 01:04 PM
  2. copy and paste linked cells plus 1 or more
    By ngs007 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-30-2014, 05:12 AM
  3. If Statement Linked to Copy Paste Function
    By ahpintern2 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-18-2014, 10:49 AM
  4. [SOLVED] How do I copy and paste a linked formula?
    By mrssteelerhall in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-15-2013, 11:17 AM
  5. Skip Cells in a Copy/Paste-Style Function
    By Jbm444 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2010, 02:09 PM
  6. quick way to copy-paste a formula linked to cells in another file
    By iniakupake in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-25-2005, 10:56 PM
  7. [SOLVED] Copy and Paste Formula Without the linked file path
    By KevinB in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-24-2005, 07:06 PM

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