mightymacros Excel Utilities
A new workbook tool called Create Workbooks has been added to the toolset, it converts sheet tabs into separate workbooks. Also new functions have been added to Count Filter, including a total count, item percentages and blank cell stats. The option to filter Excel dates is now included within all the filter tools. Create Tabs has been updated and can now split data of varying date formats onto separate tabs.
Another new filter tool called 'Count Filter' has been added to the tool set. The tool provides a quick descending order count of recurring items within a range or table and loads the item count into a list box. A filter can then be applied by simply selecting any item within the displayed list. 'Create Tabs' and 'Click Filter' can now be used on Excel tables.
A new filter tool has been added called 'Click Filter' The tool lets you filter by any item, simply double clicking the item on the sheet.
Create tabs has been updated. The revision provides the option to select the header row containing the column-titles. This preserves the row information that may be above the column titles when the data is split onto separate tabs. Additional changes include the provision to split information by date onto separate tabs. Tab names are based on the data being split. Tab name length and character requirements are now configured to be within Excel's requirements.
mightymacros Excel Utilities Help File
Installation Instructions For Installing An Excel VBA Add-in
4. Select Macro Settings And Check 'Allow access to VBA project object model'
Select any Macro Setting other than 'Disable all macros without notification'.
7. Paste The xlam File Into The Browse Window
Make sure that Browse Path is C:\Users\[User]\AppData\Roaming\Microsoft\AddIns
Paste File and click OK button.
Note: If updating an earlier version uncheck the add-in in the add-ins dialog view then click OK to close the dialog, then follow the above steps to reopen the Add-ins dialog and go to the Browse window, paste and replace the old file, then select OK.