| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
reset a workbook each month saving a copy and using totals to rest
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
reset a workbook each month saving a copy and using totals to rest
?B?c3F1aXJyZWwxMg==?=
wrote in : 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving Auto-Filtered Data (or deleting the rest) | Excel Discussion (Misc queries) | |||
| How can I copy margin setups etc. from one worksheet to the rest? | Excel Worksheet Functions | |||
| How to copy some text in columns and rest in rows | Excel Discussion (Misc queries) | |||
| How do i copy conditional formating formulas from 1 row to rest | Excel Discussion (Misc queries) | |||
| Month to date sales - reset in new month??? | Excel Worksheet Functions | |||
Linear Mode
