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
<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
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
Last edited by a moderator: