reset a workbook each month saving a copy and using totals to rest

[squirrel12]

Ecel 2007. I have created a set of spreadsheets which I want to use on a
monthly rolling basis. I would like to know how to save a copy of the sheets
at the end of a calandar month and to reset the sheet entries for the start
of the new month using the totals from the previous month as the start
figures for the new month. is this possible. I am fairly new to excel with
limited knowledge of it.

 

[stepan]

Ecel 2007. I have created a set of spreadsheets which I want to use on
a monthly rolling basis. I would like to know how to save a copy of
the sheets at the end of a calandar month and to reset the sheet
entries for the start of the new month using the totals from the
previous month as the start figures for the new month. is this
possible. I am fairly new to excel with limited knowledge of it.

for you being new. open the excel file. save as rename it to a new month
name. manuplate the data totls and clear out old. save as new file name.

there are many other ways but that is the simplest