Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using date to generate new workbook
Sorry, I posted this to new users as well.
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
is there a formula to generate a calendar month date rather than . | Excel Worksheet Functions | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |