Saving sheet as new for 2021 without data

Joerg Schmidt

Hallo,

I use a sheet for claimed damages. It has been filled with a huge number of data

I wonder if there is a way to save the sheet as a new and blank sheet (with the automatizations, formats a.s.o.)

for 2021 and following years.

If I just save it as new and than delete the data of 2020 new issues will be added automatically in row 700+

Hope you have a nice idea ;-)

David Joyeuse

Hi @Jörg Schmidt Novum Hospitality

Reading this like this I would suggest to save the whole sheet as a new template, and saves everything.

Then creates new sheet out of the templates for 2021+ years

Also make sure when you delete rows to effectively removing all the lines.

Selecting all datas and pressing delete just remove Data.

In your case, click right and select "delete".

Your sheet will be blank and your first line will be row 1 not 700+ :)

David Joyeuse

Hi @Jörg Schmidt Novum Hospitality

Reading this like this I would suggest to save the whole sheet as a new template, and saves everything.

Then creates new sheet out of the templates for 2021+ years

Also make sure when you delete rows to effectively removing all the lines.

Selecting all datas and pressing delete just remove Data.

In your case, click right and select "delete".

Your sheet will be blank and your first line will be row 1 not 700+ :)

Joerg Schmidt

hope it works - Thank you ;-)