Skip to main content
edited tags
Link
Source Link

Automatically create new Sheets like 1st 2nd 3rd 4th and so on

I am using google Sheets

I want to do the following but I cant figure out how:

We do have like a daily Report sheet. We need it for every day, so I create 31 new Sheettabs 1 for each day and give the whole Spreadsheet the name of the Month.

I want to automatize it because its way too much work to copy like every day for every month over and over. Is there a script to do so? Its enough for me that I have like 1 Button to start the Script and its copying the first day as a template and paste it 30 times, so it would be easy to do some changes aswell.

thanks!