Split Workbook by Worksheets in Excel

July 05, 2017 - by Bill Jelen

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.