This is my first post to this forum so apologies if this is one of those questions that get asked 100s of times.

I am using VBA to ask user various questions which results in the automatic generation of product quotation (costs, discounts etc).

largely it is working fine but I am having trouble calculating totals.

I use a template sheet which is copied I then INSERTROWs into the copy based on the users responses.

In the template I have various rows detailing sub-totals / totals.

As rows are inserted the SUM function does not necessarily automatically update itself. i.e. the SUM may start life as SUM (E1) (an arbitrary blank cell). After I have inserted X number of rows I expected the SUM function to refresh itself to say SUM(E1:E10).

Is there a better way of doing this - Am I expecting too much?