MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Split Workbook by Worksheets in Excel

July 05, 2017 - by Bill Jelen

Split Workbook by Worksheets in Excel

You might have two reasons to want to split a workbook where each worksheet becomes a new workbook.

First, perhaps you just used the Show Report Filter Pages feature in Excel but need to send each sheet to a different department. To see how to use this, watch this Podcast 2106 starting at 7:58.

Or - you want to use the Power Query Combine Files feature but all of your sheets are in a single workbook. See the Power Query example in Podcast 2077. Or - you have some other business reason.

I recorded this video showing the free MrExcel Workbook Splitter:

Download the zipped workbook from here.

Bill Jelen is the author / co-author of
Excel Subtotals Straight to the Point

I used to use the Subtotals feature daily after downloading mainframe data. This book covers every tip and trick for using Subtotals.