If you are a business analyst, you receive worksheets that calculate the same data each month, such as product sales for different areas and/or parts of the company. Once you receive these worksheets, you need to combine (consolidate) them by collecting data from various workbooks, creating a summary table in one workbook to perform analysis on the data.
Another example is consolidating budgets from different departments into the entire company budget. We can use PivotTables to achieve this, but the Consolidate feature allows us to automatically ensure that all the changes made to all of the worksheets show up in a consolidated worksheet. Let's work through the following steps to set up a summary sheet:
- Open the ...
