In our example, we have data for 3 years expenditure on tea, coffee and milk. Consolidate data in multiple worksheets within the same workbook If you are using an older version (Excel 2003 or older), this tip may not work for you. NOTE: The following processes will work in Excel versions: 2007, 2010, 20.
This example contains some tips from Edmund, one of our Excel experts, and will help you decide how to organise your data before you start summarising it to get easily understandable results. The screen may look daunting but like all great things, good planning is the key.
Data Consolidation is an incredibly useful tool that help you understand and present your data quickly and easily. The trouble is, working with Data Consolidation can be tricky! Don’t be put off. In other words, the Data Consolidation function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily. Data Consolidation allows you to gather together your data from separate worksheets into a master worksheet.
