Consolidate data from multiple worksheets in Excel 2007
To use the consolidate feature in Excel 2007 click on the data tab and then select consolidate. You can consolidate or summarize data from multiple worksheets in the same workbook or different workbooks. You can consolidate, for example, the sales figures of all your branches whose data you have kept in different worksheets. You can use the consolidate feature to summarize the salaries of your employees over a year. You can not only add data but you can also use functions like max, min, average, etc with the consolidate function.
Duration : 0:2:38
[youtube tXHiu01WGto]