Split Table Wizard for Microsoft Excel

Split Table Wizard instantly splits an Excel worksheet across multiple tables based on key values in selected columns. Use this add-in if you have a large table with complete pieces of information that you need to have in separate spreadsheets. With Split Tables for Excel you can:- Select columns with the key values by which to split the data.- Indicate if your table has headers.- Insert the resulting tables into the current or new Excel workbook.- Choose to insert each new table into a separate workbook.- Select the folder for saving the split tables.- Copy a header to all split tables. - Name the inserted worksheets by key column value or by number.