Excel Simple Consolidation & Automatic Update v1.2d (DoneEx protected)

While existing excel functions can do consolidations it affects the format of the consolidated excel sheets and data.

We have developed an excel macro which can create a consolidated sheet which retains the original format of the excel sheets & data to be consolidated.

Also any changes to the source data can be automatically updated to the consolidated sheet with a click of a button and a few simple steps.

This is an excel macros which does simple consolidation of accounts from multiple sheets from different workbooks, into a single workbook then into a single sheet. The step by step instructions on how to use this macros is attached to the PDF document.

Key Features:

1. Retains Format

• While existing Excel functions can perform consolidations, they affect the format of the consolidated Excel sheets and data.
• Our Excel macro can retain the original format of the excel sheets & data to be consolidated.

2. Customization and Flexibility: Our Excel macro is customized and provides flexibility in selecting sheets to be consolidated.
3. Programmatic and Guided Approach: Our Excel macro provides a more programmatic and guided approach, which copies sheets from different workbooks, consolidates data, and creates a new sheet.
4. Automation: With a click of a button and a few simple steps and changes can be automatically updated to the consolidated sheet.

Note: this add-in will only work properly if all the sheets to be consolidated are standardised.

Additional Features:

1. In addition, we have included an add-in to help check if headers of the consolidated sheet and all the source sheets are the same and are properly standardized.
2. We have also included an add-in that checks for simple errors, such as non-numeric values in formulas, by evaluating precedent cells and providing a detailed error report (which includes the location of the precedent cells causing the errors). The details are provided in the instructions in the attached PDF document.

Important Note: License Key

• This excl workbook is protected using DoneEx XCell Compiler.
• To use this product user will need to message Customer Name, Customer Email & Customer Computer id which user can get by runing the workbook for the first time and clicking on "Copy Computer Id", only then can the license key be generated and sent back to the user.
• An email will be automatically sent to the customer after the purchase has been made, requesting for the above details.
• Please reply to the auto-generated email with the requested details. (Please check if the email has been sent to your spam folder)
• After you receive the license file, you need to place it in the same location or folder where you put/download the "Simple Consolidation & Automatic Update v1.2d" file.
• Note: The DoneEx XCell Compiler license ensures that the generated license is locked to the user's PC (cannot be used on more than 1 PC), meaning if the user wishes to use this product on multiple PCs, they will have to purchase this product again to obtain another license.

Thank you, and we hope that you will find this product beneficial.