ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   move a sheet out of my workbook and place in another folder? (https://www.excelbanter.com/excel-discussion-misc-queries/125522-move-sheet-out-my-workbook-place-another-folder.html)

trishb123

move a sheet out of my workbook and place in another folder?
 
I am trying to move a worksheet out of my excel workbook into another folder,
as it is a new year and I need to start a new worksheet, I havce done this in
the past years and cannot remember how I did it, any suggestions?

[email protected]

move a sheet out of my workbook and place in another folder?
 
right click on the sheet and go to move or copy. Select either a
different workbook or a new workbook. be sure to check the box thats
says copy sheet.


George Nicholson

move a sheet out of my workbook and place in another folder?
 
-Right click the tab of the sheet you want to move. Select "Move or Copy"
-On the resulting dialog, specify a To Book value of "(new book)", and check
"make a copy" (if appropriate). Click OK
-Save the newly created book with the name and location of your chosing.

HTH


"trishb123" wrote in message
...
I am trying to move a worksheet out of my excel workbook into another
folder,
as it is a new year and I need to start a new worksheet, I havce done this
in
the past years and cannot remember how I did it, any suggestions?




[email protected]

move a sheet out of my workbook and place in another folder?
 
right click on the sheet and go to move or copy. Select either a
different workbook or a new workbook. be sure to check the box thats
says copy sheet.



All times are GMT +1. The time now is 06:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com