Microsoft Office Tutorials and References
In Depth Information
You can ensure that the data in the target cell reflects any changes in the original cell by
creating a link between the two cells. Instead of entering a value into the target cell by
typing or pasting, you create a formula that identifies the source from which Excel will
derive the target cell’s value and updates the value when it changes in the source cell.
To create a link between cells, open both the workbook that contains the cell from which
you want to pull the value and the workbook with the target cell. Then click the target
cell and type an equal sign, signifying that you want to create a formula. After you type
the equal sign, activate the workbook with the cell from which you want to derive the
value, click that cell, and then press the Enter key.
When you switch back to the workbook with the target cell, you see that Excel has filled
in the formula with a reference to the cell you clicked.
For example, the reference =’[FleetOperatingCosts.xlsx]Truck Fuel’!$C$15 gives three
pieces of information: the workbook, the worksheet, and the cell you clicked in the
worksheet. The first element of the reference, the name of the workbook, is enclosed
in square brackets; the end of the second element (the worksheet) is marked with an
exclamation point; and the third element, the cell reference, has a dollar sign before
both the row and the column identifier. The single quotes around the workbook name
and worksheet name are there to account for the space in the Truck Fuel worksheet’s
name. This type of reference is known as a 3-D reference, reflecting the three
dimensions (workbook, worksheet, and cell range) that you need to point to a group of cells
in another workbook.