Automatically split the data in an Excel worksheet into multiple new separate Excel workbooks. Split the data for all values or for only the selected values in one field. EZ-Split presents a list of the unique values in the selected split-by field from which to choose. New workbooks are automatically named using the value of the split-by field contained in the workbook. The formatting of the original worksheet is retained in the new individual workbooks. EZ-Split is sold separately or can be used free-of-charge with the purchase of EZ-Format. EZ-Split splitting features are completely integrated into EZ-Format. This latest version automatically copies all worksheets referenced in the data formulas of the worksheet being split. Includes feature for emailing split workbooks to either an embedded email address or to a lookup email address. EZ-Split splits data in Excel Lists, Excel Tables and Fixed Excel Subtotals. Split fixed Excel Subtotals retain all subtotal formatting including the outline levels and the additional XL-Subtotal formatting features. EZ-Split now includes the four free-forever features found in XL-Subtotal: (1) fixing the bugs in Excel subtotals, (2) switching between subtotals below and subtotals above, (3) turning subtotals off to work with the data and then back on, and (4) switching to standard Excel subtotals.
This review was originally posted on VersionTracker.com. I have had this product for over a year now and it just keeps getting better!
You can split any columns data (all or any value set) into worksheets or workbooks with all the other columns in just a couple of clicks. Into workbooks or worksheets and there is no limit to the number.
Now you can split tabs into workbooks, spread numerical values against another columns' values and even split up fields like lastname, first name all in just seconds!
The product is not sold separately but is available from the mfg as a freebie when any of their other products are bought. As little as $29. Wow!
Version 9.1 adds support of Excel 2013 and Windows 8. The Excel Toolbar can be optionally hidden on the standard Excel Add-ins Ribbon. There are new menu options for Purchasing, Activating, Re-Registering, Self-Registering and checking on the Status of the Add-in (Trial, Expired, or Registered). Reduced the time required to split a worksheet. Splits Excel 2007/2010 Tables with or without Totals. Includes fixes, enhancements and improved install for Excel 2007 / 2010.