Microsoft Office Tutorials and References
In Depth Information
Consolidating multiple sets of data
Consolidating multiple sets of data
into a single workbook
When you create a series of worksheets that contain similar data, perhaps by using a
template, you build a consistent set of workbooks in which data is stored in a predictable place.
For example, consider a workbook template that uses cell C5 to record the number of calls
received from 9:00 A.M. to 10:00 A.M. by the Northeast distribution center.
7
Using links to bring data from one worksheet to another gives you a great deal of power
to combine data from several sources into a single resource. For example, you can create a
worksheet that lists the total revenue just for certain months of a year, use links to draw the
values from the worksheets in which the sales were recorded, and then create a formula to
perform calculations on the data. However, for large worksheets with hundreds of cells filled
with data, creating links from every cell is a time-consuming process. Also, to calculate a
sum or an average for the data, you would need to include links to cells in every workbook.
Fortunately, there is an easier way to combine data from multiple worksheets into a single
worksheet. By using this process, called data consolidation , you can define ranges of cells
from multiple worksheets and have Excel summarize the data. You define these ranges in
the Consolidate dialog box.
 
Search JabSto ::




Custom Search