Hi,

This is my first post so I hope it is in the right forum.

I have a spreadsheet with subtotals on and we have a problem inserting
new rows. I thought that when a row was inserted above the subtotal
row, the subtotal would update automatically - but it doesn't.

Basically, we need to add news rows on a regular basis above the
subtotal row *and *update the subtotal.

This is what we want to happen -

Before

2 3 4
0 2 5
2 2 0
4 7 9 (Subtotal)


After

2 3 4
0 2 5
2 2 0
0 0 2 (new row)
4 7 11 (Subtotal)

Hope this makes sense! How can we get the subtotals to update each
time a new is inserted above them?

Kind regards,

Alison


--
Alison1016
------------------------------------------------------------------------
Alison1016's Profile: http://www.excelforum.com/member.php...o&userid=34563
View this thread: http://www.excelforum.com/showthread...hreadid=543241