Excel 2007 and reports in order to aggregate more than the result of a separate worksheet, you can work for each individual table of data together into a master worksheet. These worksheets with the main work table in the same workbook, but also in other workbooks. The data is the combination of data together in order to be able more easily to the data of regular or ad hoc basis to update and summary.

For example, if you have one for each regional office expenses worksheet data, use the combined data of these expenses into the company’s expenditure on the work table. The main worksheet that can be included in total sales across the enterprise and on average, the current inventory levels and product sales.

To the data together, please use the “Data” tab on the “Data Tools” group “together” command.

Together according to location – in chronological order according to the same table all the data and their location on the same

1, in a separate worksheet for each set of data to be combined.

How to set up data

To ensure that data used for each list (list: contains a series of data lines, or use the “Create a list of” command as a data table assigned to the function of a series of lines.) Format: the first line of each column has a label the same column contains similar data, and not in the list, blank lines or empty out.

, Respectively, each region will be placed in a separate worksheet. Do not put on any regional merger of the work table.

To ensure that each region have the same layout.

Name of each region: Select the entire region, and then in the “formula” tab of the “named cell” group, click “named range” next to the arrow, and then in the “Name” box, type in the region name.

2, contains the main work to show the merger of the table data range, click the upper left cell.

Note: to ensure that the cells in the lower right side to leave enough data to merge cells. “Together” command under the need to fill in the region.

3, in the “data” tab of the “Data Tools” group, click the “merger.”

4, in the “Function” box, click Microsoft office Excel data used to calculate the aggregate merger function (summary function: is a calculation of the type used in PivotTable or combined together form source data, or in the list or database to insert automatic subtotals. Examples of summary functions Sum, Count and Average.).

5, if the worksheet in another workbook, click the “Browse” to find documents, and then click “OK” to close the “Browse” dialog box.

In the “quote” box, enter the file path followed by an exclamation point.

6, type the name of the regional designation, and then click “Add.” To repeat this step for each region.

7, to determine together how to renew hope. Do one of the following:

To set up together, so that it changes the source data in the Automatic Updates, select “Create a link to the link source data” check box.

Points only when the worksheet is located in the middle of the other workbook in order to select the check box. Once you select this check box, then the merger can not be included in the calculation of the cell and regional change.

To set up together, so that you can change the calculation of the merger, including the cells and the region together to manually update, clear the “Create links to source data links” check box.

8, Please “tab position” under the box blank. Excel is not the source region of the row or column labels are copied to the combined calculation. If you need to merge the data for labeling, please copy from a source region or manually enter them their.