Consolidating your Data in Microsoft Excel 2010
Consolidate Consolidate means to summarize data placed on different sheets (having same layout) into a single sheet. To do so you need to organize and arrange your data as per following specifications : Make sure that each data range should be in list format along with having same layout for each sheet Each data range should be on different sheet but not on the sheet where you want to consolidate data Selected Data Range where consolidated data will be placed, having sufficient space towards down n left side After organizing, Select the cell from where you want to begin the consolidated date and it should have sufficient available space towards its Right and Downside Then select Consolidate command available under DATA Ribbon. A dialog box, like shown below appears, where you need to specify the data details for consolidation Consolidate Dialog Box Specify the Cell Range for Each reference Sheet and then Click ADD to add in the reference list. Specify where the Labe...