Microsoft Office Tutorials and References
In Depth Information
Consolidating Your Data—Getting It All Together
Figure 7–23. Workbook protection: different objects protected here
Note the dialog box isn’t titled Protect Workbook, but that is what it’s offering to do. And as you see, it’s
passwor d con tr ol l abl e , an d y ou’ l l be aske d to con fi r m that passwor d shoul d y ou choose on e . Cl i ck OK,
and as stated earlier, you won’t be able to reposition worksheets, change their names, or delete any of
them. To turn Protect Workbook off, just click the Protect Workbook button again. If you’ve protected
the wor kbook wi th a passwor d, y ou’ l l be aske d to suppl y i t.
Consolidating Your Data—Getting It All Together
You may have constructed a workbook—or inherited one—in which similar data are compiled on
separate worksheets, say, the sales totals compiled by a set of salespersons across a set of years, each
year assigned its own worksheet. If you want to then combine these yearly totals into one summary
worksheet, in order to see how much each salesperson has earned overall, you can use Excel’s
Consolidation tool to do the job.
To demonstrate how Consolidate works, download the Sales By Year workbook from
www.apress.com. You’ll see a small listing of salesperson data for the years 2008, 2009, and 2010. Note
each sheet is identically organized—that is, the ordering of the salespersons is the same in each year,
and each sheet’s data column is headed Sales (remember that by grouping worksheets you can do this
easily—entering labels in one grouped sheet reproduces those same labels in the same cells in the
others). On each sheet name the range A4:B8 Sales08, Sales09, and Sales10, respectively (Figure 7 -24):
Figure 7–24. The 2008 sheet data
 
Search JabSto ::




Custom Search