Removing all data for a new month and save

[benkong2]

I have a worksheet that summarizes data by weeks. All data for one week is on one row. At the end of the month I want to press a button or run a macro that saves the sheet as mm/yy/sheetname then deletes all data except my formulas so that I can start over for the next month.

_________________
I love to learn

[ This Message was edited by: benkong2 on 2002-02-20 17:05 ]

[anno]

you might instead try creating an excel template (see the help topic) in which you insert your formulas. it just means you'll name the workbook at the beginning of the month (when you first save it) rather than at the end of the month, but you'll always have the template to create a workbook for a new month.

[ This Message was edited by: anno on 2002-02-20 17:29 ]

[ This Message was edited by: anno on 2002-02-20 17:30 ]