Create a Link Between Worksheets or Workbooks : Link « Editing « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Editing
3. Link

Select the source cell or range.
           Click the Home tab. Then click the Copy button.

Select the destination cell or destination range.
           Click the Paste Options button, and then click Link Cells.

2.19.Link
	2.19.1.	Create a Link to Another File
	2.19.2.	Create a Link Between Worksheets or Workbooks