Code for find and replace with autosum (upwards)?

[Trikageon]

Here's what I have (Ignore the x's, etc., they're just to show blank space):

<C>xxxxxxx_123_XXXXX
xxxxxxx_____XXXXX
xxxxxxx_456_XXXXX
xxxxxxx_789_XXXXX
---------------------
101112 Total 131415

</C>
Is there a way to find and replace that word "Total" with something like autosum going upwards (so it only adds up 456+789, using this example)? The number of rows, as well as the cells address where they reside in vary, so I can't use any hard coding to particular ranges - that's why I need something like auto sum. Any ideas?

 

[jim may]

And the Underscores? Are they real Underscores?

 

[Doogs2009]

What is he asking? i dont get it! Can he not just write like sub-total events or something after say, a certain number of rows, then sub-total the figures. You'd have to write code to count the rows, insert a new row in between then add up certain data thats meets criteria, then insert the sub-total. Sounds too easy!! Can anyone write that $%^&*.

Craig

 

[Trikageon]

Ignore the underscores too. Imagine all of that is just data from the adjacent cells.