+ 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
    143

    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
    Valued Forum Contributor BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    965

    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
    143

    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
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,675

    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!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

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

    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 Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    10,981

    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
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

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

    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. [SOLVED] 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