Create new worksheets based on values in a column

Step 1, download the excel add-on from here.

Step 2, Unzip the file.

Step 3, Open your spreadsheet on EXCEL.

Step 4, Double click “DXL.xlam” to load the add-on.

Step 5, Click “DataXL” on the top right and then Click “Ranges“, choose “Split Range into sheets” from the menu.

Step 6, Choose how many rows in the header and which column will be refereed for creating new tabs.

All done.