Generating a blank worksheet at the start of the month
 

I have a worksheet containing sales data and hours worked for several
employees for a period of one month. the names of the employees and the codes
for the products sold remain unchanged from month to month. The sales data
for each employee is entered each day by the manager of the store. I want to
create a macro that will at the start of every month:

1. automatically save the previous month's workbook

2. create a new workbook with the only the fields for the rostered hours per
employee and quantity of items sold left blank for data entry throughout the
month.

Could someone please point me in the right direction.

http://class.et.byu.edu/ce270/vbaexcel_primer/intro.htm
http://msdn.microsoft.com/office/und...g/excel/gettin
gstarted/default.aspx?pull=/library/en-
us/odc_xl2003_ta/html/odc_super.asp
http://www.exceltip.com/excel_links.html
http://www.mvps.org/dmcritchie/excel/getstarted.htm
http://www.the-excel-advisor.com/excel-macros-vba-
tutorial.html

-----Original Message-----
I have a worksheet containing sales data and hours worked
for several
employees for a period of one month. the names of the
employees and the codes
for the products sold remain unchanged from month to
month. The sales data
for each employee is entered each day by the manager of
the store. I want to
create a macro that will at the start of every month:

1. automatically save the previous month's workbook

2. create a new workbook with the only the fields for the
rostered hours per
employee and quantity of items sold left blank for data
entry throughout the
month.

Could someone please point me in the right direction.
.