Inserting totals of the Rows aboe where there is a blank line

I have a lengthy spreadsheet that has a blank row between a week ending and the next week beginning - I need to insert totals for columns J and K wherever there is a blank line for the rows above until it gets to the next blank line - can you help me write a script for this?

[TABLE="width: 704"]

[tr]

[TD="class: xl68, width: 64, bgcolor: transparent"]A
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]B
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]C
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]D
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]E
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]F
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]G
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]H
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]I
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]J
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]K
[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"]Aaron Bramble
[/TD]
[TD="class: xl64, bgcolor: transparent"]Emily Elmy
[/TD]
[TD="class: xl63, bgcolor: transparent"]Monday 09 05 16
[/TD]
[TD="class: xl65, bgcolor: transparent"]######
[/TD]
[TD="class: xl64, bgcolor: transparent"]E9
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]680
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]710
[/TD]
[TD="class: xl66, bgcolor: transparent"]14.47
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0.5
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]7.24
[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl64, bgcolor: transparent"]Aaron Bramble
[/TD]
[TD="class: xl64, bgcolor: transparent"]Emily Elmy
[/TD]
[TD="class: xl63, bgcolor: transparent"]Monday 16 05 16
[/TD]
[TD="class: xl65, bgcolor: transparent"]######
[/TD]
[TD="class: xl64, bgcolor: transparent"]E9
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]680
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]710
[/TD]
[TD="class: xl66, bgcolor: transparent"]14.47
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0.5
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]7.24
[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"]Aaron Bramble
[/TD]
[TD="class: xl64, bgcolor: transparent"]Emily Elmy
[/TD]
[TD="class: xl63, bgcolor: transparent"]Monday 23 05 16
[/TD]
[TD="class: xl65, bgcolor: transparent"]######
[/TD]
[TD="class: xl64, bgcolor: transparent"]E9
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]680
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]710
[/TD]
[TD="class: xl66, bgcolor: transparent"]14.47
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0.5
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]7.24
[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl64, bgcolor: transparent"]Aaron Bramble
[/TD]
[TD="class: xl64, bgcolor: transparent"]Emily Elmy
[/TD]
[TD="class: xl63, bgcolor: transparent"]Monday 30 05 16
[/TD]
[TD="class: xl65, bgcolor: transparent"]######
[/TD]
[TD="class: xl64, bgcolor: transparent"]E9
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]680
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]710
[/TD]
[TD="class: xl66, bgcolor: transparent"]14.47
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0.5
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]7.24
[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]total here
[/TD]
[TD="class: xl63, bgcolor: transparent"]total here
[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"]Aileen Mccarthy
[/TD]
[TD="class: xl64, bgcolor: transparent"]Ana Paula Gingao Amaral
[/TD]
[TD="class: xl63, bgcolor: transparent"]Monday 09 05 16
[/TD]
[TD="class: xl65, bgcolor: transparent"]######
[/TD]
[TD="class: xl64, bgcolor: transparent"]E9
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1125
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1155
[/TD]
[TD="class: xl66, bgcolor: transparent"]14.47
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0.5
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]7.24
[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"]Aileen Mccarthy
[/TD]
[TD="class: xl64, bgcolor: transparent"]Bryony Goodchild
[/TD]
[TD="class: xl63, bgcolor: transparent"]Monday 09 05 16
[/TD]
[TD="class: xl65, bgcolor: transparent"]######
[/TD]
[TD="class: xl64, bgcolor: transparent"]E9
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]405
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]450
[/TD]
[TD="class: xl66, bgcolor: transparent"]14.47
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0.75
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]10.85
[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"]Aileen Mccarthy
[/TD]
[TD="class: xl64, bgcolor: transparent"]Bryony Goodchild
[/TD]
[TD="class: xl63, bgcolor: transparent"]Monday 09 05 16
[/TD]
[TD="class: xl65, bgcolor: transparent"]######
[/TD]
[TD="class: xl64, bgcolor: transparent"]E9
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]700
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]730
[/TD]
[TD="class: xl66, bgcolor: transparent"]14.47
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0.5
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]7.24
[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"]Aileen Mccarthy
[/TD]
[TD="class: xl64, bgcolor: transparent"]Michelle Peck
[/TD]
[TD="class: xl63, bgcolor: transparent"]Monday 09 05 16
[/TD]
[TD="class: xl65, bgcolor: transparent"]######
[/TD]
[TD="class: xl64, bgcolor: transparent"]E9
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]915
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]945
[/TD]
[TD="class: xl66, bgcolor: transparent"]14.47
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0.5
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]7.24
[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"]Aileen Mccarthy
[/TD]
[TD="class: xl64, bgcolor: transparent"]Bryony Goodchild
[/TD]
[TD="class: xl63, bgcolor: transparent"]Tuesday 10 05 16
[/TD]
[TD="class: xl65, bgcolor: transparent"]######
[/TD]
[TD="class: xl64, bgcolor: transparent"]E9
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]405
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]450
[/TD]
[TD="class: xl66, bgcolor: transparent"]14.47
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0.75
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]10.85
[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"]Aileen Mccarthy
[/TD]
[TD="class: xl64, bgcolor: transparent"]Bryony Goodchild
[/TD]
[TD="class: xl63, bgcolor: transparent"]Tuesday 10 05 16
[/TD]
[TD="class: xl65, bgcolor: transparent"]######
[/TD]
[TD="class: xl64, bgcolor: transparent"]E9
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]700
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]730
[/TD]
[TD="class: xl66, bgcolor: transparent"]14.47
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0.5
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]7.24
[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"]Aileen Mccarthy
[/TD]
[TD="class: xl64, bgcolor: transparent"]Caroline Reason
[/TD]
[TD="class: xl63, bgcolor: transparent"]Tuesday 10 05 16
[/TD]
[TD="class: xl65, bgcolor: transparent"]######
[/TD]
[TD="class: xl64, bgcolor: transparent"]E9
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1155
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1185
[/TD]
[TD="class: xl66, bgcolor: transparent"]14.47
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0.5
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]7.24
[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]total here
[/TD]
[TD="class: xl63, bgcolor: transparent"]total here
[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"]Aileen Mccarthy
[/TD]
[TD="class: xl64, bgcolor: transparent"]Michelle Peck
[/TD]
[TD="class: xl63, bgcolor: transparent"]Tuesday 10 05 16
[/TD]
[TD="class: xl65, bgcolor: transparent"]######
[/TD]
[TD="class: xl64, bgcolor: transparent"]E9
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]920
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]950
[/TD]
[TD="class: xl66, bgcolor: transparent"]14.47
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0.5
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]7.24
[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"]Aileen Mccarthy
[/TD]
[TD="class: xl64, bgcolor: transparent"]Ana Paula Gingao Amaral
[/TD]
[TD="class: xl63, bgcolor: transparent"]Wednesday 11 05 16
[/TD]
[TD="class: xl65, bgcolor: transparent"]######
[/TD]
[TD="class: xl64, bgcolor: transparent"]E9
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]945
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]975
[/TD]
[TD="class: xl66, bgcolor: transparent"]14.47
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0.5
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]7.24
[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"]Aileen Mccarthy
[/TD]
[TD="class: xl64, bgcolor: transparent"]Caroline Reason
[/TD]
[TD="class: xl63, bgcolor: transparent"]Wednesday 11 05 16
[/TD]
[TD="class: xl65, bgcolor: transparent"]######
[/TD]
[TD="class: xl64, bgcolor: transparent"]E9
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]375
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]420
[/TD]
[TD="class: xl66, bgcolor: transparent"]14.47
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0.75
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]10.85
[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"]Aileen Mccarthy
[/TD]
[TD="class: xl64, bgcolor: transparent"]Ewa Pstragowska
[/TD]
[TD="class: xl63, bgcolor: transparent"]Wednesday 11 05 16
[/TD]
[TD="class: xl65, bgcolor: transparent"]######
[/TD]
[TD="class: xl64, bgcolor: transparent"]E9
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1145
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1175
[/TD]
[TD="class: xl66, bgcolor: transparent"]14.47
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0.5
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]7.24
[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]total here
[/TD]
[TD="class: xl63, bgcolor: transparent"]total here
[/TD]

[/tr]

[/TABLE]

Re: Inserting totals of the Rows aboe where there is a blank line

Thank you very much for replying but this stops at the first 'SumRow' stating Variable not defined

Re: Inserting totals of the Rows aboe where there is a blank line

Hopefully this will get to you

So to complete the job I need the sub totals in J and K

(also if you are able to help?)

In column E we have to insert the Sunday Week Ending date (the last day worked may not always be a Sunday) we have manually done this part the way down - if you know of a way to do that - that would be also really useful!

Once all the Subtotals and Week Ending are in - the Name in Column B will be copied to the same line as 'KEEPIT' (I have a code for that) and all lines that do not have the word 'KEEPIT' will be removed (I have a code for that) - Leaving all lines with KEEPIT including the Name in Column B the week ending and the totals for that week