Forum Discussion

ace29fts's avatar
ace29fts
Copper Contributor
Aug 15, 2018

Is it possible to copy sheetA from workbook2 (WB2) to workbook1 (WB1) ?

I am trying to add a sheet with formulas referencing cells in other sheets within the same workbook. I have however emailed out this workbook for someone to enter data, so I am creating the new worksheet in a duplicate copy of the original workbook. Would it be possible to copy this new sheet to the original workbook if all other sheets remain untouched? 

 

So to complete the subject line above, I am trying to :

     Copy  sheetA from workbook2 (WB2) to workbook1 (WB1) where WB2 is a duplicate copy of WB1 except that sheetA was added to WB2, and has formulas referring to other sheets within the workbook.

excel
Formulas and Functions

2 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Aug 15, 2018

    Hi,

     

    You can copy it to the WB1, but the formulas in the sheetA will still refer to the WB2.

    Please check out this https://support.office.com/en-us/article/move-or-copy-worksheets-or-worksheet-data-47207967-bbb2-4e95-9b5c-3c174aa69328 to learn how to copy a worksheet from a workbook to another one.

     

    After you copy the worksheet sheetA from WB2 to WB1, the formula will show up as the following example:

    ='[WB2.xlsx]sheetB'!A1

     

    The solution is to replace the workbook name with nothing using Find and Replace tool as follows:

     

    After you type the full workbook name wrapped in square brackets, press Replace All.

     

    Regards

Resources