Notifications And Revisions

1. mightymacros Dat Add-in

Build 1.7.0.17808 released 30th of Aug 2020
Minor bug fixes and security update.

Build 1.6.9.32630 released 4th of Aug 2020
Fixed unwanted error message when application is checking for updates on new the server.

Build 1.6.8.24686 released 28th of July 2020
This Program is now Freeware.

Build 1.6.5.17226 released 26th of June 2020
Major revision of queries to improve response time and report outcomes 

Build 1.6.4.20410 released 27th of May 2020
Modified comments upload to handle the same items detected by a different rule 

Build 1.6.2.28132 released 21st of April 2020
Now compatible with the latest version of SQL Server Express 2019 LocalDB

Build 1.6.1.25637 released 2nd of April 2020
Updated ribbon and security settings within the add-in

Build 1.5.9.35441 released 16th of December 2019
Bug fixes, included the prevention of an unwanted error an message occurring when opening Excel when internet is down.

Build 1.5.7.20688 released 10th of December 2019
Check for updates function added to ribbon menu. To receive the update information, install the program using the exe file in the zip package.

Build 1.5.4.20158 released 19th of November 2019
Minor modifications made to the stats form to order the date selection criteria

Build 1.5.2.21331 released 14th of November 2019
The stats function for duplicate invoices now includes the total items commented and the percentage that are duplicates. In addition, the charts multiple range selection method may have failed in certain regions. This has been updated and tested and hopefully now is fixed for all the other regions.

Build 1.5.1.26826 released 7th of November 2019
Updated Stats function providing charts for duplicate invoices and savings by quarter

Build 1.4.1.31439 released 12th of October 2019
Bugfix applied to support the upload of invoices data where duplications have text case differences in the invoice reference.

Build 1.4.0.20571 released 9th of September 2019
The option is now available to set a minimum amount for the duplicate report output. The option should help to reduce noise, allowing for a clearer focus on higher value items. This option replaces the need to set a minimum amount for numeric queries, with an overall minimum now being set.

Version 1.3.1 released 24th of August 2019
Minor update to archive form.

Build 1.3.0.22829 released 3rd of July 2019
New optional fields for entry of payment date and payment status have been added and the currency field is now included on the report output.

Build 1.2.1.37138 released 27th of March 2019
More changes made to improve the capture of duplicates within the different reference and different date rule

Build 1.2.0.37132 released 25th of March 2019
Changes made to improve the capture of duplicates within the different reference rule.

Build 1.1.8.18275 released 4th of Dec 2018
Setup configuration changed with additional options implemented to improve the outcome for finding duplicate invoices. Improve the capture of duplicates within the different reference rule.

Build 1.1.7.17873 released 17th of Sep 2018
Setup now configured to automatically check and load SQL Server LocalDB on install, using new Setup.exe file. In addition, a new free trial period is available with this download.

Build 1.1.6824.22568 released 7th of Sep 2018
The option is now available to set custom row header names that match the headers on your upload sheets. The update should simplify the upload process.

Build 1.0.6732.23564 released 7th of June 2018
Corrections made to Archive Form, and other forms.

Build 1.0.6731.34631 released 6th of June 2018
Archive manager now displays the database size. Aim is to assist database management by maintaining a database size of under 10 GB. The help file is now included and can be opened by clicking the 'About' button on the Dat add-in menu.

Build 1.0.6706.23404 released 12th of May 2018
Fixed issue with setup file not showing uninstall in add and remove programs. If affected right click the original setup file or download a copy, then select uninstall

Build 1.0.6705.30901 released 11th of May 2018
Improved results for rules relating to different date and different vendor.

Build 1.0.6688.24997 released 24th of April 2018
Minor update implemented to improve the programs memory usage.

Version 1.0.6 released 4th of April 2018
Please note SQL Server Express LocalDB version 11.0 is no longer supported on Windows 10

2. mightymacros Dat Lite

Build 1.1.7.17558 released 30th of Aug 2020
Minor bug fixes and security update.

Build 1.1.6.24306 released 28th of Aug 2020
This update includes bug fixes and improvements made to the different amount rule.

Build 1.1.4.32105 released 4th of Aug 2020
Fixed unwanted error message when application is checking for updates on the new server.

Build 1.1.3.23175 released 27th of July 2020
Dat Basic is now the new mightymacros Dat Lite with Stats and charts

Build 1.1.2.19977 released 27th of May 2020
Modified comments upload to handle the same items detected by a different rule.

Build 1.1.0.31201 released 21st of April 2020
Now compatible with the latest version of SQL Server Express 2019 LocalDB
 
Build 1.0.9.26433 released 2nd of April 2020
Updated ribbon and security settings within the add-in

Build 1.0.8.28030 released 16th of December 2019
Bug fixes, included the prevention of an unwanted error an message occurring when opening Excel when internet is down.

Build 1.0.5.15322 released 10th of December 2019
Check for updates function added to ribbon menu. To receive the update information, install the program using the exe file in the zip package.

Build 1.0.1.16348 released 1st of November 2019
Updates were made to the ribbon menu and the attached help file
mightymacros Dat Lite build 1.0.0.30737 released 12th of October 2019
A free cut-down version of Dat add-in has just been released and is now available from the product page.

3. mightymacros Dat Basic

Build 1.0.6.17890 released 27th of May 2020
Modified comments upload to handle the same items detected by a different rule 

mightymacros Dat Basic - new release on 1st of April 2020
New variant of Dat add-in released. Refer to the download page for product details

4. mightymacros AddIn Installer

Version 1.0.4 Released on 4th of May 2020
Fixed bug when installing using Run as Administrator. Rich text box read me display set to read only.

Version 1.0.3 Released on 19th of April 2020
Automates and simplifies the installation and update process when installing VBA Excel Add-ins.

5. mightymacros Excel Utilities

Version 4.6.9 Released 30th of October 2020

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.

Version 4.6.6 Released 19th of October 2020

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.

Version 4.6.4 Released 16th of October 2020

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.

Version 4.6.2 Released 8th of October 2020

This update includes a new tool called Delete Rows and is located under the row tools menu. This tool eliminates the need of applying and selecting filters and cells to remove unwanted rows. It also provides the option to keep the original data in place by choosing to output the results onto a new worksheet. 

Version 4.5.9 Released 9th of September 2020

The latest modification brings the tool inline with Excels default color sort, providing the ability to color sort on a filtered list.

Version 4.5.8: Released 7th of September 2020

Minor bug fix applied to the row color sort to improve functionality when applied to data where the top row is not the first row. In cases where the top row is row 2 or row 3, the row number should be selected in the forms drop box before selecting the input column range.

Version 4.5.7: Released 22nd of August 2020

Modified the 'Next Tab' function to include clearing the existing range selection. Now only a single click is required to input the new range.
This change will also help to mistake proof the operation by forcing the selection of a new range entry when moving to a new sheet.

Version 4.5.6: Released 22nd  of August 2020

A simple row color sort has been added to the tool set collection under the row tools menu. The tool will sort row colors on a sheet having up to 7 colors. The sort configuration can be stored and used across multiple worksheets. A typical use might be applicable when sorting row data highlighted with styles of Good, Bad and Neutral. 

Version 4.5.2: Released 25th of July 2020

Fixed bugs with Multi-Find and Multi-Filter paste option. Added an additional button to the Multi-Find providing the choice to either search by a selected range or to search by a select column and eliminated the bug when only one item is added to search list.

Version 4.5.1: 

The create tabs function under row tools has been modified to accommodate splitting table data where column headers are not on the top row, by simply highlighting the table column header and it's data the tool will split and group the data onto separate tabs. Highlighting the whole column will also split the data if the table headers are on the top row.

Version 4.4.9: 

The multi-find has a new paste from the clipboard button and the auto-backup reminder method has been revised on multiple forms and hopefully now is more user-friendly. Also included in the update are bug fixes to the multi-find and replace form.

Version 4.4.4: 

The multi-filter has a new paste option available to add items to the search list box from Windows clipboard. Items must be copied as a single column list. The form settings for Case, Paste, and Filter can now be stored as defaults.


Version 4.4.1: 

A new and simpler copy transpose function has been added, as well as a new macro to split table data onto separate sheets based on recurring groups within the column range, it's called 'Create Tabs' and is positioned under the 'Row Tools' menu. This version also includes improvements to the bookmark tool and some bug fixes.