Split Table by Column Tool

This is an Excel VBA tool that will split a Table into separate worksheets, based on the contents of one of the table's columns.

It is available on Github at https://github.com/ceybers/excel-table-split-column.

What does it do?

You select a column in your table, then the tool will create a new worksheet for each unique value in that column, with a copy of the table in each worksheet that only contains rows with that value.

Why did you make this tool?

This is a common enough request in the office world that it was worth the time to create a tool to automate the process.

The tool does some basic checks such as whether or not the sheet names will be valid (no weird characters), and that it won't try to create a ridiculous amount of new worksheets.