Total a column and repeat headings

[marcidee]

Please can someone help me with a script - I have a sheet that has a blank row every time a new name appears in column A

What i would like is to:

Place a total of the figures in column G - total in column F (last row)
Repeat the headings from row 1 on each blank line

Example of end result below

Thank you for your help

Name	Timesheet	P/E Date	Company	Time worked	Pay Rate	Total Pay
						0
Abimbola Dunsin (Dunsin) B	1	Thu 08 Aug 2019	Peter Howes	0.75	9.00	6.75
Abimbola Dunsin (Dunsin) B	1	Fri 09 Aug 2019	Peter Howes	0.5	9.00	4.5
Abimbola Dunsin (Dunsin) B	1	Sat 10 Aug 2019	Phillip Mercer	0.25	9.00	2.25	13.5
Name	Timesheet	P/E Date	Company	Time worked	Pay Rate	Total Pay
Afaque Solangi	1	Mon 12 Aug 2019	Mohsen Taheri	7	9.00	63
Afaque Solangi	1	Tue 13 Aug 2019	Mohsen Taheri	7	9.00	63
Afaque Solangi	1	Wed 14 Aug 2019	Mohsen Taheri	7	9.00	63	189
Name	Timesheet	P/E Date	Company	Time worked	Pay Rate	Total Pay
Amalia Gatou B	1	Thu 15 Aug 2019	Amanda King	1	9.00	9
Amalia Gatou B	1	Fri 16 Aug 2019	Amanda King	0.25	9.00	2.25
Amalia Gatou B	1	Sat 17 Aug 2019	Amanda King	0.25	9.00	2.25	13.5

<tbody>
</tbody>

I had posted this question on another forum however I did not find a solution - the link to this question is below:

https://www.ozgrid.com/forum/forum/h...es-in-column-a

The first part of the link is irrelevant as I have been fortunate to be given the solution in this forum by -'fluff' however I am looking for a solution to this question as I require both methods

 

[marcidee]

Unfortunately that didn't work either - it's inserting 3 lines and no totals or headings

Name	Timesheet	P/E Date	Client	Time Worked	Pay Rate	Total Pay	0
Name	Timesheet	P/E Date	Client	Time Worked	Pay Rate	Total Pay
Afaque Solangi	1	##########	Mohsen Taheri	7	9.00	63.00
Afaque Solangi	1	##########	Mohsen Taheri	7	9.00	63.00
Afaque Solangi	1	Fri 09 Aug 2019	Mohsen Taheri	7	9.00	63.00
Afaque Solangi	1	Fri 09 Aug 2019	Samer Aboul-Hosn	0.75	9.00	6.75
Afaque Solangi	1	Fri 09 Aug 2019	Samer Aboul-Hosn	1	9.00	9.00
Afaque Solangi	1	Fri 09 Aug 2019	Samer Aboul-Hosn	1	9.00	9.00
Amalia Gatou B	1	##########	Amanda King	1	9.00	9.00
Amalia Gatou B	1	##########	Amanda King	0.25	9.00	2.25
Amalia Gatou B	1	##########	Amanda King	0.5	9.00	4.50

<colgroup><col><col><col span="2"><col><col><col span="2"></colgroup><tbody>
</tbody>

 

[MickG]

Try this Example file with two examples and compare with your data:-
https://app.box.com/s/ucxhx64g7yezer95gbgl9uyvdaoebjvn

 

[marcidee]

I think I may have found the problem - my later versions contain a formula - I will try again later (as I am out for while) with your code that worked last night and fingers crossed that will sort it. I will confirm later - thank you