License: Shareware $29.95
OS: WinXP,WinVista,WinVista x64,Win7 x32,Win7 x64,Windows2000,Windows2003,WinServer,
Requirements: Microsoft Excel 2010 32-bit and 64-bit, Excel 2007, 2003
Publisher: Add-in Express Ltd.
Homepage: http://www.add-in-express.com
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.
The wizard will guide you through the splitting process: easily select the table you need to separate, choose the key column or columns and pick the destination and names for the resulting tables.
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
This smart add-in works with Excel 2003 – 2010. Just try it and it will make the splitting routine a breath!
