Copy and Paste Formula

Discussion in 'Excel' started by marste7, Aug 27, 2013.

  1. marste7

    marste7

    Joined:
    Aug 27, 2013
    Messages:
    1
    Likes Received:
    0
    I have this formula in one book ='Page 2c'!C10+'Page 2c'!F10

    When I copy it to another book it adds the name of the book I am copying from

    ='[c_534156_NCRRC_1130_2013.xlsx]Page 2c'!C10+'[c_534156_NCRRC_1130_2013.xlsx]Page 2c'!F10


    How can I copy this formula and have it refer to the current book?

    Thanks
     
    marste7, Aug 27, 2013
    #1
    1. Advertisements

  2. marste7

    XLPadawan

    Joined:
    Jun 9, 2016
    Messages:
    32
    Likes Received:
    5
    Location:
    Allen, TX
    Copy only the text of the formula and paste INTO a cell in the other workbook. Here's how:
    1. Select the cell the formula is in
    2. Press F2 key
    3. Shift + Home
    4. Ctrl-C
    5. Esc key
    Select the cell in the other book where you want the formula to be pasted
    1. F2 key
    2. Ctrl-V
    3. Enter key
     
    XLPadawan, Jun 16, 2016
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.