Forum Discussion
excel
How can I transfer only part of one workbook to a new workbook.
2 Replies
- I suppose you want to either move or copy a sheet from one workbook to another
To move:
1. Right-click on the specific sheet to move
2. Select Move or Copy
3. Select Book1 from the drop down
4. Click OK.
The sheet will be moved entirely to a new Book1 workbook
To copy:
1. . Right-click on the specific sheet to copy
2. Select Move or Copy
3. Select Book1 from the drop down
4. Check create a copy in the bottom left corner
5. Click OK.
The sheet will be copied to new Book1 and you still have it in the original workbook
Hope this answers your question
