Transfer worksheet
Solved/Closed
Related:
- Transfer worksheet
- How to transfer worksheet to another excel file - Guide
- Transfer data from one excel worksheet to another automatically ✓ - Forum - Excel
- Transfer data from invoice to worksheet automatically with vba - Forum - Excel
- Transfer specific data from one worksheet to another for reports - Guide
- Transfer a worksheet to another Excel workbook: without VBA - Guide
2 replies
aquarelle
Aug 24, 2008 at 01:50 AM
- Posts
- 7104
- Registration date
- Saturday April 7, 2007
- Status
- Anonymous
- Last seen
- May 24, 2022
Aug 24, 2008 at 01:50 AM
Hello,
You have to click on on the tab of the sheet you want to copy, do a right click with the mouse to select "Move or copy" from the list, a box will open:
1) "In the workbook :", a drop-down list appears to select the folder where you want to copy the sheet.
* The name that appears is the folder where you work.
* If you scroll down the list, appears "new workbook", then you can create a new workbook which will be copied on the sheet.
Then follows a list of all files that are open, you choose the workbook where you want to copy the sheet.
2) "Before the sheet :" A list box to choose in the workbook that you have selected, where the sheet will be placed.
3) a check box "Create a copy" : it is very important to check this parameter value if you want to make a copy (be careful : if you don't check this box, the sheet will move without creating copy then the sheet will not be in the origin folder.
By doing this, there is no change formulas, the formulas remain as they were written at the outset.
So, I hope this will help you.
Best regards
You have to click on on the tab of the sheet you want to copy, do a right click with the mouse to select "Move or copy" from the list, a box will open:
1) "In the workbook :", a drop-down list appears to select the folder where you want to copy the sheet.
* The name that appears is the folder where you work.
* If you scroll down the list, appears "new workbook", then you can create a new workbook which will be copied on the sheet.
Then follows a list of all files that are open, you choose the workbook where you want to copy the sheet.
2) "Before the sheet :" A list box to choose in the workbook that you have selected, where the sheet will be placed.
3) a check box "Create a copy" : it is very important to check this parameter value if you want to make a copy (be careful : if you don't check this box, the sheet will move without creating copy then the sheet will not be in the origin folder.
By doing this, there is no change formulas, the formulas remain as they were written at the outset.
So, I hope this will help you.
Best regards
Dec 1, 2015 at 02:22 AM