Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding the next month to a daily volume tracking sheet.
Hello,
Im trying to automate a tedious task at work but Im not sure how to go about it. We track daily volumes on a spreadsheet. Column 1 would have each business day for the month. Column 2 through 8 would have various volumes for different items that we enter each day. This piece cant be automated do to the source of the volumes but what I would like to automate is adding the next month to the top of the sheet and moving the previous month down. I cant simply copy and paste the previous month because the number of business days in each month varies. I would also like to add the busness days. The thing that makes this so tedious is that it has to be done on several sheets. Any suggestions would be appreciated. Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a new template spread sheet on the first day of a new month | Excel Discussion (Misc queries) | |||
Tracking an amount that accrues Daily | Excel Discussion (Misc queries) | |||
daily tracking of expenses | Excel Discussion (Misc queries) | |||
Tracking daily sales templates? | Excel Discussion (Misc queries) | |||
tracking daily and monthy sales | Excel Discussion (Misc queries) |