Calc Guide

Sheet containing data
for Branch 3.
Sheet containing
combined data for all
branches.
Figure 133: Combining data from several sheets into a single sheet
The spreadsheets have been set up with identical structures. The
easiest way to do this is to set up the first Branch spreadsheet, input
data, format cells, and prepare the formulas for the various sums of
rows and columns.
1) On the worksheet tab, right-click and select Rename Sheet....
Type Branch1. Right-click on the tab again and select Move/Copy
Sheet...
2) In the Move/Copy Sheet dialog, select the Copy option and select
Sheet 2 in the area Insert before. Click OK, right-click on the tab
of the sheet Branch1_2 and rename it to Branch2. Repeat to
produce the Branch3 and Combined worksheets.
194 OpenOffice.org 3.x Calc Guide