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