Please can you help with a script.
I have a spreadsheet that goes on for numerous lines - I would like to create a news tab every time there is a name change in Column A - and copy the contents of all columns (B - G) - the name could appear on several rows.
ie in the example below 3 new tabs created - one for each name - the tabs renamed with that person's name and all 6 columns columns copied
Thank you for your help
<tbody>
</tbody>
I have a spreadsheet that goes on for numerous lines - I would like to create a news tab every time there is a name change in Column A - and copy the contents of all columns (B - G) - the name could appear on several rows.
ie in the example below 3 new tabs created - one for each name - the tabs renamed with that person's name and all 6 columns columns copied
Thank you for your help
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 |
Abimbola Dunsin (Dunsin) B | 1 | Sun 11 Aug 2019 | Theresa Darling | 0.25 | 9.00 | 2.25 |
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 |
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 |
Amalia Gatou B | 1 | Sun 18 Aug 2019 | Amanda King | 0.5 | 9.00 | 4.5 |
<tbody>
</tbody>