18.01.06 Linking Multiple Cells to the Same Takeoff Result
AA-00584
The Live Link Add-in has been discontinued by ConstructConnect effective 6/1/2023 and can no longer be downloaded or installed. If you are already using Live Link, it will continue to function for some time, although we no longer provide support for this feature.
We encourage you to review the Related Articles at the bottom of this article on ways of exporting your takeoff results to Excel (and other formats).
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
- Click once in the first cell
- Double-click the Result you want to link to that cell
- Click once in the next cell where you want to insert that Result
- Double-click the Result
- Click once in the last cell
- 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  |