Data Consolidation

Data Consolidation To summarize and report results from data on separate worksheets, you can consolidate the data from each separate worksheet into one worksheet (or master worksheet). The worksheets you consolidate can be in the same workbook as the master worksheet or in other workbooks.

Short Keys --> Alt + A + N

31KB

Consolidate.rar

Example of Data Consolidation