Split Worksheets

The macro in the workbook below will cycle through all worksheets in the active workbook, and then save each worksheet as an independent workbook named with the sheet name and saved in the same directory as the original workbook.  This macro does not alter the original workbook.

AttachmentSize
splitsheetsintobooks.xls29 KB

Split Worksheets