O'Reilly logo

Microsoft® Office Excel® 2003 Step by Step by Curtis Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required