			SELECT A TOPIC		SELECT A TOPIC BELOW
	Excel 2000		Worksheets and Workbooks		Linking worksheets Using links to share information between worksheets Linking and pasting tips

Using links to share information between worksheets

Links allow you to share and update information between worksheets. Information is copied from a source worksheet and pasted into a destination worksheet; each time a change is made to the source worksheet, the destination worksheet is automatically updated.


1.	Copy the source cell(s): select the cell(s) containing the formulas or data you want to use in your link, then click the Copy icon .
2.	Paste the cell(s): go to the cell where you want to paste the link — this can be in the same worksheet or workbook, or in a separate workbook — then choose Paste Special from the Edit menu and click the Paste Link button.