Insert and Copy

Location on ribbon: Tab DVD Addin → Group Cells and Rows → Menu Insert Menu

Command ID: btnInsertCopyBelow

What it does

Replicates a row template to many places in a table: for every target row it inserts exactly as many blank rows as the source block has, then copies the template into them. Use it when a repeating block has to follow each item — three "Material / Labour / Equipment" rows under every work item in a cost estimate, or a "Subtotal" row after each group in a bill of quantities. Shortcut: Alt+C.

How to use

1. Click Insert and Copy in tab DVD Addin → group Cells and Rows → Insert Menu (or press Alt+C).
2. The first prompt appears: "Select source area" (one or more rows). Drag-select the template block on the sheet and click OK.
3. The second prompt: "Select target areas (Ctrl-click for multiple)". Select the rows below which the template should be inserted; hold Ctrl to pick several separate areas, then click OK.
4. The add-in works bottom-up so earlier positions do not shift: for each target row it inserts the blank rows and copies the source block into them.
5. Press ESC while it runs to stop early — everything processed so far is kept.
6. Clicking Cancel on either prompt exits without changing anything.

Example

A detailed cost estimate has work-item rows at rows 10, 25 and 40. You have prepared a three-row template at A100:H102 containing Material, Labour and Equipment with their formulas.

Press Alt+C → select source A100:H102 → select targets: click row 10, Ctrl-click row 25, Ctrl-click row 40 → OK. Each work item now has exactly three cost rows beneath it with the template's formatting and formulas intact, and everything below shifts down.

Notes

• The block is copied as-is (values, formulas, formatting); relative references adjust to the new position.
• Keep the source block outside the area being shifted (for example at the bottom of the sheet), otherwise its own position can move while the command runs.
• Bulk insertion is not cleanly undone by a single Ctrl+Z — save the file before running it on a large table.
• While running, the add-in turns off events and screen updating for speed; a briefly frozen screen is normal.
• If the target selection spans several consecutive rows, each of those rows gets its own copy of the template — select only the rows you really need.

Related

• Insert Rows — insert a number of blank rows without copying anything.
• Insert Columns — widen the table instead.
• Delete blanks — clean up surplus rows if you over-inserted.
• Merge rows — finish the layout once the table has all its rows.