I am trying to create an invoice where there are rows that will be added that include a calculation (Col B * Col C = Subtotal) on each row. I have a macro that will insert a row and copy of the formula to the new row, but the formula retains the Column and Row numbers from the previous row.

If I create a row, and copy the formula, say [=B2*C2] into the new row, it remains B2 and C2. I have tried using a row reference or just a column reference, but it doesn't seem to work.

I know it does in Excel 2010, but I cannot maintain control over the page and formatting -- which is necessary for the way the invoice is used.

I did figure out that if I use the formula =SUM(ABOVE), new rows are included in the total, but I can't figure out a way to copy the formula or automate writing a formula to reflect the new row number.

Any help? This is, of course, an urgent matter.

Thanks

Hi ejtoll,

Basically, you have three choices:
1. Recreate the formula field from scratch for each new row;
2. Copy an existing formula and edit its code; or
3. Implement a relative referencing formula that will update itself when copied to a new row.

To see how to do this and a wide range of other calculations in Word, check out my Microsoft Word Field Maths Tutorial: https://www.msofficeforums.com/word/...-tutorial.html
In particular, look at the item titled 'Relative Referencing In Tables'. You might also benefit from the tutorial's discussion of the quirks you might encounter when using SUM(ABOVE) and its relatives.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]