Accounts Consolidation

Excel Spreadsheet

We already have on our website the template Multi-range Pivot table, which shows how ranges or tables that are not identical can be consolidated with the help of pivottables.  The problem with pivot tables, however, is that the layout of the pivot table is often different from the layout of the source tables, which would not be helpful, for example, in the consolidation of accounts of branches or subsidiaries with identical layouts.  In this template the layout of the consolidation remains exactly the same as the layout of the source tables, which have identical layouts.

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.