Sometimes working with Excel can be as complicated as coding, but it’s not always like this. In case you work in one workbook that you’d like to move to another one, there is a simple solution that doesn’t require knowing macros or VBA codes – it can be done in a few simple clicks. Read on to find out how to transfer a worksheet to another Excel file.
Note: If you want to move your worksheet into an existing workbook, it has to be open. Otherwise, it won’t appear on the list.
4. Select where you’d like to insert a worksheet in the Before Sheet section.
5. Check mark the Create a Copy tab and then click OK. You will see your worksheet successfully added to another workbook.
Note: Be careful : if you don't check the Create a Copy box, the sheet will move without creating a copy and you will not be able to find the original in the folder.