Consolidating data multiple sources validating dropdowns

This is also an ideal time to set up your template with Excel tables.There are two ways to consolidate data: by Category or by Position.

Heterogeneous Sources Heterogeneous sources are of different types, for example CRM, Oracle EBS, Peoplesoft, JDEdwards, and so on.For example, if you have an expense worksheet for each of your regional offices, you might use consolidation to roll these figures into a master corporate expense worksheet.This master worksheet might also contain sales totals and averages, current inventory levels, and highest selling products for the entire enterprise. Click in the Reference box, select the range A1: E4 in the district1 workbook, and click Add. Repeat step 4 for the district2 and district3 workbook. Check Top row, Left column and Create links to source data.Data consolidation refers to the collection and integration of data from multiple sources into a single destination.