Hi,

What I want to do is the following:

I have a worksheet formatted as a printable table, with heading rows, then
the table value rows, and then a row that sums various columns. What I need
to do is to find the last row in the table value rows, add a new row between
this row and the row that sums the column values, and then put the info
enetred in the form into this new row. It also must update the sum() field
to include this row.

As an example, my worksheet looks something like this:


Heading
Date:

Ref | Location | Area | Comments |
| | | |
A | Left | 500 | LHS |
B | Right | 325 | RHS |
Totals | 825 |

What I need to do is insert a row after Ref "B", and then add data there
from a form. The totals must also be updated to reflect this added row.

How can I do this?

Thanks
Brad Clarke