Linking separate Excel Workbooks

Hi Catherine

To link up your work books.

1. Start by opening the 3 workbooks (marketing, advertising and the master workbook).

2. Select the cell in the master workbook where you want the data from the marketing workbook to appear.

3. Type = then navigate to the marketing workbook using the Taskbar (or by clicking View, Switch Windows then selecting the marketing workbook).

4. Select the cell to link to and press Enter.

Then repeat these steps to link to the advertising workbook.


Paste Linking
If you want to link to a block of cells there is different way of linking that might have been shown on your Excel Intermediate course.

Start by selecting the file containing the source data, for example your marketing workbook.
Highlight the block of cells to link.
Select Home, Copy (or press Ctrl+c)
Navigate to your master workbook using the Taskbar.
Select the destination cell for the block.
Choose Home, Paste option (or Paste Special).
Click Paste Link.

You can use either method to create links between Excel workbooks.

Once the links are made close all the files saving the master workbook.

Opening a Linked workbook
After setting up the links you'll be prompted with a message saying Enable Content whenever you open the master workbook. Say enable to see the latest value in the linked files.

Use Data, Edit Links to see or open the linked files.

Hope that helps, let me know how you get on.

Regards
Doug
Best STL