'Is there a way to automatically change an excel spreadsheet back to a template every night at midnight?

Basically I have and excel workbook where the first sheet is detailed daily sales. These values update a weekly report (sheet 2). Every night I would like to reset all the values in the daily report back to zero, while saving the data in the weekly report. I am wondering if there is a way to do this and if possible a clue as to how to start. I have python and some command line experience but I have never automated anything before.

Thanks!

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Is there a way to automatically change an excel spreadsheet back to a template every night at midnight?

Sources

Related Questions