18.01.06 Linking Multiple Cells to the Same Takeoff Result

You can link multiple cells to the same Takeoff Item Result. This is especially handy if you want to calculate different materials or labor off the same Takeoff quantity.

Linking More than One Cell to the Same Takeoff Item Result

In the screenshot below, we want to use the same "Length" result for each cell, we're just going to apply different pricing to the same value.

Linking One Cell At a Time

1. Click once in the first cell
2. Double-click the Result you want to link to that cell
3. Click once in the next cell where you want to insert that Result
4. Double-click the Result
5. Click once in the last cell
6. Double-click the Result to create the last Live Link.

There is no effect on your takeoff when you link a result to multiple cells, and the great thing, when you update your takeoff (in CC-Takeoff), all linked cells update, automatically.

If you realize you linked a cell (or cells...) to the incorrect Result, it is easy to link to a different Result.

Linking a Group of Selected Cells to the Same Takeoff Result

The one-by-one method works best if the cells are not adjacent. However, you can also select multiple cells in your workbook and link them all to the same Result in one step.

Just select the cells, and double-click on the Result. Excel creates a Live Link to the same Result in each cell. You can change or delete one without affecting the others.

Linking a Takeoff Result to an Excel Cell

Changing the Takeoff Item Result to which a Cell is Linked