Copying multiple sheets to new Workbook

G

Guest

Is it possible to "split" mutliple worksheets into mutiple workbooks in a
single function?

For example, if there are 15 worksheets in one workbook that I would like to
"split" into 15 individual workbooks, is it possible to move them all at once
as opposed to performing an individual copy to new workbook for each tab?

Any help is appreciated,
Ashley
 
G

Guest

Worked wonderfully, thank you! I hope you don't get rid of the webpage
anytime soon, I've forward the information to several people in the office! ;)
 

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

Merge Multiple workbook sheets into one workbook 0
A macro code to print multiple sheets in different w.books 3
Editing Data in Multiple Worksheets/Workbooks 1
consolidate workbooks to worksheets in one workbook? 1
Combine multiple workbooks into one workbook 1
Protect but Allow Edit Ranges in Multiple Sheets 6
moving worksheets 1
Splitting Data from One Worksheet to Many Automatically 3

Top