Google Sheets Scripts - Create New Tabs with Date Names, Sort Tabs by Date, Copy and Delete data to Log Tab
Budget: £20 – £250 GBP
This project is to create a series of scripts which will
1. create a new tab by copying the Master Template
2. name the tab with the date 10 days from today (see below for format of name)
3. populate the new tab A2:A25 with the date (see below for the format of the date) – please make the range able to be edited by me
4. copy the data from today’s tab to the LOG tab at the first blank line
5. delete today’s tab
6. sort the tabs in order (excluding Master and Log which will be hidden) from tomorrow’s date to the newly created date (10 days from today)
I will create the time triggers to run the scripts.
1. create a new tab by copying the Master Template
2. name the tab with the date 10 days from today (see below for format of name)
3. populate the new tab A2:A25 with the date (see below for the format of the date) – please make the range able to be edited by me
4. copy the data from today’s tab to the LOG tab at the first blank line
5. delete today’s tab
6. sort the tabs in order (excluding Master and Log which will be hidden) from tomorrow’s date to the newly created date (10 days from today)
I will create the time triggers to run the scripts.