Welcome to Lesson 2 of the Advanced Microsoft Excel Tutorial. In this lesson we will cover linking data. I hope you enjoy the lesson.

Linking Data

Step 1: Creating Links between cells in the same worksheet

Click the cell that contains the data that you want to link to, then click Edit and then Copy. Click the cell that you want to link from, and then click Edit and then Paste. Click on the Paste Options button (shown) and then click Link Cells.

Step 2: Create List
Open the workbook that contains the cell to be linked and the workbook of the cell to be linked to. In the destination workbook click File and then Save. Select a cell or cells you want to link from. On the Window menu, click the name of the source workbook and then click the worksheet that contains the cells you want to link to. Select the cells you want to link to. Complete the formula. When you finish entering the formula, press Enter.