Consolidating data in excel 2016 multiple worksheets updating ad aware
In our example, we have data for 3 years expenditure on tea, coffee and milk.
And Kutools for Excel is a very handy tool, why do not free install it to have a try?
The ranges you consolidate do not have to be of the same size in each worksheet, the number of rows or columns might be different from sheet to sheet.
And yet, you can still consolidate the data into a summary sheet. To start using the Data Consolidation tool, you need to select an empty sheet in the workbook as your master worksheet or add a new one if necessary. Select the upper-left cell of the area where you want the consolidated data to appear.
For our data we want to add up the values so we’ll set the Function to Sum.
Click in the Reference area and select the first data range to consolidate – to do this you will need to click the Sheet tab i.e.