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
split_sheets_into_books.xls62 KB

Split Worksheets