Explanation

You can consolidate data stored on different worksheets in the same workbook.

Example workbook:

  • Sheet1 → Sirsa
  • Sheet2 → Hisar
  • Sheet3 → Fatehabad
  • Sheet4 → Consolidated Report

Workflow

Branch Sheets

↓

Data → Consolidate

↓

Select Function

↓

Add References

↓

Create Consolidated Report

Important

For best results, source tables should have consistent labels and structure.

Practice

Create four worksheets:

  1. Sirsa
  2. Hisar
  3. Fatehabad
  4. Consolidated

Combine the first three into the fourth.

PreviousNext