excel+course - Manage linked work books

Hi Tracey

Thank you for your question.

To create a link between two workbooks, you have two options. Have both workbooks open first before following either of these options.

Option 1
1. Select the cell you want to create the link in.
2. Type in =
3. Select the workbook that contains the data you wish to link to.
4. Select the cell you wish to link to and press Enter.
The link is created.

Option 2.
1. Have the file that contains the data you wish to link to open on your screen.
2. Copy the cell that contains the data you wish to link to.
3. Select the workbook that you want to create the link in.
4. Paste into the cell which will contain the link.
5. Use the Paste Options smart tag (has picture of the Paste button on it) and select Link Cells.
The link is created.

I hope this helps.
Amanda