+ Reply to Thread
Results 1 to 4 of 4

Copy and Paste Formuals only, not Content

  1. #1
    Registered User
    Join Date
    09-24-2008
    Location
    NB Canada
    Posts
    5

    Copy and Paste Formuals only, not Content

    I have an accounting spreadsheet with totals and grand totals down 1300 rows.

    Is there a way to copy and paste the formulas only without the content of the other?

    So basically, only subtotals and totals are copied

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Copy and Paste Formuals only, not Content

    Copy formula, Paste Special and select Formulas
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Registered User
    Join Date
    09-24-2008
    Location
    NB Canada
    Posts
    5

    Re: Copy and Paste Formuals only, not Content

    No, to be more specific, I have the following example,
    Red Dots 3
    Blue Dots 5
    Total Dots 8

    Red Squares 1
    Blue Squares 6
    Total Squares 7

    Total Shapes 15

    What I want to do is hi-lite the row with the data and formula, and just copy the formula so the data is left out.

    If I do what you say, it pastes formula and data
    Last edited by cvs2kids; 03-15-2014 at 10:02 PM. Reason: spelling

  4. #4
    Registered User
    Join Date
    11-08-2013
    Location
    Sacramento, California
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Copy and Paste Formuals only, not Content

    Hi cvs2kids,

    So, I'm assuming that you want just formulas for the subtotals and totals copied (after copy they would all equal 0 because the formulas would be referring to empty cells) and it would be too time consuming to select just the individual subtotals because you have many rows. If this is the case then one might have to use VBA. You may not want to take the time delve into that realm tho. You can find tutorials using google searches on setting up new VBA modules in excel. Also, the file would have be saved as a macro-enabled excel file.

    This code would copy only the formulas from column A and paste them to column B (on the same rows) in the worksheet you are currently in.
    Please Login or Register  to view this content.
    See the part that says: Range("A1:A2000"). You can change the A2000 to however many rows you have. Depending on some factors, the code could take a few seconds to run, but it didn't take long for me.

    I'm not an excel expert and there may be a better way to do this than what I have provided, but this is one way.

    Goodluck,

+ 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. Copy cell content to clipboard to paste into a pdf
    By kevinm3u in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-06-2014, 03:30 PM
  2. [SOLVED] Copy cell A1 and paste value into B1 if B1 has content, paste to B2...etc
    By mhopke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-09-2012, 09:39 PM
  3. Copy and paste only cells with content, row wise in a new WB
    By wils_mathew in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-30-2012, 01:05 AM
  4. copy & paste a specific content
    By ghappybee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-02-2010, 11:44 PM
  5. Copy and paste row based on cell content
    By BDan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2006, 11:20 AM

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