Accounts Consolidation

Excel Spreadsheet

This template demonstrates two methods for consolidation of tables that have identical layouts, but by using VBA code a cleaner solution can be obtained. The full version allows access to the VBA code that you can adapt to suit your own situation, and is ideal for monthly consolidations, etc.

The editable version of this worksheet is without restrictions and passwords, allowing you to freely view and change the code, etc to meet your own requirements. Price will be subject to the current rate of UK VAT where applicable.

We recommend that you add our email address ( to the contacts in your email program to help prevent our emails from going into the spam/junk mail folder.

We do require your email address in order to send the link to your free worksheet, and it would be good to use your name in a personal thank you. Our privacy policy is your assurance that any personal information is safe with us.