Consolidate
Excel's consolidation feature uses the Consolidate dialog to collect your consolidation settings, including the worksheet ranges you want to include in the consolidation and the type of consolidation you want to perform.
Choose Consolidate from the Data menu.
The Consolidate dialog appears.
Click the January sheet ...
Get Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
