Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
export worksheets to other workbook
hey all,
is there a way to export all my worksheets in workbook to another workbook? thanks, rodchar |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
export worksheets to other workbook
One way -
Right click any sheet tab and choose "Select All", then right click the tab again and choose "Move or Copy..." and follow the prompts Another way - File- Save as "rodchar" wrote: hey all, is there a way to export all my worksheets in workbook to another workbook? thanks, rodchar |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
export worksheets to other workbook
If a one-time deal just have both workbooks open.
Select all the sheets from source book and "move or copy" to the target book. If doing this often, turn on the macro recorder to create a macro. Gord Dibben MS Excel MVP On Thu, 6 Sep 2007 06:18:07 -0700, rodchar wrote: hey all, is there a way to export all my worksheets in workbook to another workbook? thanks, rodchar |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
export worksheets to other workbook
thanks everyone for the help.
rod. "rodchar" wrote: hey all, is there a way to export all my worksheets in workbook to another workbook? thanks, rodchar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automate export to a new workbook | Excel Discussion (Misc queries) | |||
import/export data from a workbook | Excel Discussion (Misc queries) | |||
how to export worksheets into seperate files | Excel Discussion (Misc queries) | |||
is there a way to export just 1 worksheet of an entire workbook | Excel Worksheet Functions | |||
Export TextBox contents to new workbook. | Excel Discussion (Misc queries) |