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

Consolidating Worksheets

You can use the Consolidate dialog box (choose Data, Consolidate), shown in Figure 9-34, to combine the values from a set of worksheets in the same workbook or from different workbooks. The Consolidate command allows you to assemble information from as many as 255 supporting worksheets into a single master worksheet.

Figure 9-34. The default function in the Consolidate dialog box is Sum.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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