+ Reply to Thread
Results 1 to 7 of 7

Add to formula a paste value part

  1. #1
    Forum Contributor
    Join Date
    05-01-2013
    Location
    Richmond, VA
    MS-Off Ver
    Excel 365
    Posts
    164

    Add to formula a paste value part

    Is there something I can add (a formula) to the formula below so that when it brings over the value from the MAINDATA worksheet cells into the new worksheet, that is pastes the value?

    In other words, the users will save the worksheet with the MAINDATA formula into a new spreadsheet/excel file and send it to an external company, and we need to have values and not formulas in the cells.

    Fyi - I have the Excel 365


    =IF(MAINDATA!S2<>"",MAINDATA!S2,"")

  2. #2
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Add to formula a paste value part

    Even MAINDATA sheet is not available for external company, the result of last calculation will be in the cells.
    However sender or recipient can brake links with book with MAINDATA. (DATA/ Edit links )
    Last edited by BMV; 02-11-2020 at 09:12 AM.

  3. #3
    Forum Contributor
    Join Date
    05-01-2013
    Location
    Richmond, VA
    MS-Off Ver
    Excel 365
    Posts
    164

    Re: Add to formula a paste value part

    That is correct - the sheet that is saved will be in a separate Excel file. The user will right click the worksheet with the formulas, choose "Move or Copy," check the "Create Copy" box, and in the drop down select "(new book)."

    I was hoping to eliminate having to take the extra steps to copy and paste values, and see if I could bring over the values by adding something to the existing formula.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,323

    Re: Add to formula a paste value part

    A formula is a formula - it cannot turn itself into a text or number value.

    Maybe a macro? Shall I move this to the VBA section for you?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Forum Contributor
    Join Date
    05-01-2013
    Location
    Richmond, VA
    MS-Off Ver
    Excel 365
    Posts
    164

    Re: Add to formula a paste value part

    I guess I am being naively hopeful. Thank you yes, please move this to the VBA section.

  6. #6
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Add to formula a paste value part

    Fyi - I have the Excel 365
    Administrative note
    Perhaps update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version.
    Thanks

  7. #7
    Forum Contributor
    Join Date
    05-01-2013
    Location
    Richmond, VA
    MS-Off Ver
    Excel 365
    Posts
    164

    Re: Add to formula a paste value part

    I just did, thank you for the recommendation.

+ 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. Formula to move part of a value to a new cell - part 2
    By forestavekids in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-28-2016, 12:34 PM
  2. Replies: 1
    Last Post: 01-03-2016, 11:48 PM
  3. Paste part of an array
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-06-2015, 09:00 AM
  4. Replies: 0
    Last Post: 10-29-2013, 09:38 AM
  5. Copy and paste only one part of a formula
    By Voluntas in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-02-2012, 03:19 PM
  6. Replies: 3
    Last Post: 09-26-2012, 04:29 PM
  7. Cut and paste by reference part 2
    By Lunks in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-02-2006, 02:00 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