export worksheets to other workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hey all,
is there a way to export all my worksheets in workbook to another workbook?
thanks,
rodchar
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel to xml export help 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Highlighting duplicates 0
Export cell data to closed workbook 7
Excel 2003 + export of data 7
combine worksheets 1
Excel VBA 0
worksheets side-by-side 2

Back
Top