Microsoft Office Tutorials and References
In Depth Information
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 in a single
worksheet. This process, called data consolidation , enables you to 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