Consolidate Data from Other Worksheets or Workbooks : Import Export « Collaboration « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Collaboration
3. Import Export

Open the source workbook.
           Open the workbook that will contain the consolidated data.

Select the destination range.
           Click the Data tab. Then click the Consolidate button.

Click the Function list arrow, and then select the function for consolidating data.

Type the location of the data.

Or click the Expand Dialog button.

Click Add to add the reference to the list of consolidated ranges.

Select the Create links to source data check box.

Click OK.

13.3.Import Export
	13.3.1.	Export an Excel File to Another Program Format
	13.3.2.	Import a Text File
	13.3.3.	Verify a data map before you export the data
	13.3.4.	Consolidate Data from Other Worksheets or Workbooks