Summarizing Multiple Sets of Data

Summarizing Multiple Sets of Data

When you create a series of worksheets that contain similar data, perhaps by using a template, you build a consistent set of workbooks where data is stored in a predictable place. For example, in the workbook template in the following graphic, sales for the hour 9:00 a.m. to 10:00 a.m. on the first day of the month are always stored in cell D6.

Summarizing Multiple Sets of Data

Using links to bring data from one worksheet to another gives you a great deal of power in combining data from several sources in a single spot. For example, you can create ...

Get Microsoft® Office Excel® 2003 Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.