export worksheets to other workbook
 

hey all,
is there a way to export all my worksheets in workbook to another workbook?
thanks,
rodchar

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

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

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