How to create a dynamic attendance google sheet per month without the need to create another tab every month?

by

Help please!

Currently When I change the month the date only changed the data remains from previous month.

Here is the google sheet link for reference
https://docs.google.com/spreadsheets/d/1JArwx1pQq8BfsdKwL_DDjGQnzZEUM5Q4zEKa83StwMg/edit?usp=sharing

I want to create an attendance sheet that once I change the new month in Cell 5 the data from D to AH will automatically save and clear for new month.

Would you be able to help me find ways to do it?

I want to create an attendance sheet that once I change the new month in Cell 5 the data from D to AH will automatically save and clear for new month.

Thank you!

  • Select the range D9:AH16 and then press the “Delete” key

    – 

  • It’s possible that you are thinking of a script-based answer. Would you please edit the question to include your own efforts to solve the problem and/or summarise the research that you have done so that users don’t cover the same ground as you.

    – 

  • From the documentation: clear()

    – 

  • Just create an empty template for you to duplicate every month and change the starting month.

    – 

Leave a Comment