Consolidating excel worksheets

16 May

I’ve said it before, I’ll say it now and I’m sure I’ll hum this tune again next week.Today I’m tackling a common problem that’s plagued office heroes for years.There are two ways to consolidate data: by Category or by Position.Consolidation by position: When the data in the source areas is arranged in the same order and uses the same labels.

consolidating excel worksheets-46consolidating excel worksheets-38consolidating excel worksheets-20consolidating excel worksheets-13

Often we keep identically structured data in multiple spreadsheets and files.This master worksheet might also contain sales totals and averages, current inventory levels, and highest selling products for the entire enterprise.Tip: If you frequently consolidate data, it might help to base your worksheets on a worksheet template that uses a consistent layout.For example, you can use the Consolidate command to total all budget spreadsheets prepared by each department in the company or to create summary totals for income statements for a period of several years.If you used a template to create each worksheet you’re consolidating, or an identical layout, Excel can quickly consolidate the values by virtue of their common position in their respective worksheets.