Forum Discussion
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 works...
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
Thank you!