Exproting Excel Worksheet to seperate Workbook

  • Thread starter Thread starter starke1120
  • Start date Start date
S

starke1120

I have a workbook that has about 100 different worksheets in it. Is it
possible to export each worksheet to its own work book? I would like
to name each workbook the name of the sheet it contains.

Thanks,

Dave
 
You must log in or register to reply here.

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 Copy cells from one worksheet to another workseet - increment row & do again 0
Copying cells and formula from closed workbook to all sheets in open workbook 0
Macro for all Excel Workbooks to print to PDF 2
Excel Move or Copy Stopped Working? 0
Excel crashes and restarts when accessing newly created worksheet 2
How to reference a cell from anther workbook without opening it 0
Combine multiple worksheets in one Workbook into one big worksheet 6
Exporting Worksheets from a workbook and saving them as a .prn file 1

Back
Top