Home

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

ace29fts
Occasional Contributor

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.

2 Replies
Highlighted

Hi,

 

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

Please check out this link 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:

Replace Tool.png

 

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

 

Regards

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
description for autoplay blocking in settings page
HotCakeX in Discussions on
8 Replies