Frequently Asked Question

Title : Consolidate Numbers from Multiple Worksheet and Total to a Single Sheet

Information : The below consolidation will work when the data in the source areas is arranged in the same order and uses the same labels. Use this method to consolidate data from a series of worksheets, such as departmental budget worksheets that have been created from the same template.

Step 1 : Create 3 Worksheets in same Excel Workbook named (2012, 2013,2014) and worksheet to consolidate the Summary in 2015.

2012

2013

2014

Consolidate into 2015

Step 1 to Consolidate

In worksheet 2015, From the Mene Tab select DATA and from the ribbon select Consolidate.

The below screen will appear

Clicks at 2012 Worksheet

Highlight the area that you want data to be consolidated.

Clicks Add Button and you can see the cell reference will be added with the area that you have selected.

Then clicks on the 2013 Worksheet and continue to do the same process for 2013 and 2014 worksheet

Step 3 Click OK to end the Consolidation process and you can see the result as per below screen. Figure has been total up for all three years into 1 single sheet.

End