Relative Referencing


In Cubit 9, you now have the ability to copy items containing references and maintain their relationships relative to where you will be pasting them.

If the items you copy from the Estimate, Rate or Calculation Sheets include references, when you Paste with relative references, the references are maintained within the pasted selection instead of referring to the original reference source from where the items were copied.

  • When pasting relative references, you can use the Paste special from the context menu, and click Paste with relative references.
  • You can use the shortcut Ctrl + Shift + V to paste relative references.
  • You can use shortcut Shift + F4 to copy the sheet contents of the above item with relative references.

Fig 1.  Paste with relative references

Note: This feature currently works within the same job/price list only.

Paste with relative references

Relative referencing can be used within the Estimate, Rate and Calculation sheets in a job and within the Estimate and Calculation sheets in a Pricelist. When pasted, the reference will be linked to the copied item instead of the source which it was copied from.

1. Open a job that contains existing references or create a new job.

2. Copy the items by pressing Ctrl + C or right-click and select Copy.

Fig 2. Copy an item with referencing


Note: If one of your items are referencing a cell outside the selection being pasted with relative references, you will be alerted with the following window and the references will be pasted as values only

Fig 3.  Paste references outside selection alert

3. Go to the sheet where you want to paste the items and right-click anywhere on the row you want your items inserted.

4. From the drop-down menu, click Paste Special, then Paste with Relative References or press Ctrl+Shift+V.

Fig 4. Paste Special, Paste with relative references

The pasted item will now have referencing local to its new location.

Fig 5. Pasted item referencing locally


Paste with relative references from the above cell

By pressing Shift + F4, the cell above will be copied down with relative referencing.

Fig 6. Shift + F4 copies down from the cell above

Fig 7. The result of Shift + F4

0 out of 0 found this helpful



Please sign in to leave a comment.