• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Sharing Workbook Data > Consolidating Data

Consolidating Data

In some cases, you'll want to consolidate data from different worksheets or workbooks into one workbook, rather than simply linking the source data. For instance, if each division in your company creates a budget, you can pull together, or consolidate, the totals for each line item into one company-wide budget. If each divisional budget is laid out in the same way, with the budgeted amounts for each line item in the same cell addresses, then you can very easily consolidate the information without any retyping. If data in individual workbooks change, the consolidated worksheet or workbook will always be correct.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint