Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros for Daily, Weekly and Monthly Reports.
In out excel file we have 11 workbooks with running totals that update daily,
weekly and monthly reports in 3 other workbooks. We would like to make up Macros so that the reports will update automatically when run. To do this we need the daily cell reference to move one down during the week, 4 down at week end, and 2 at month end. I think it will take 3 Macros to do this but I have tried to make the reference move down one but it doesn't seem to work. How can I set up Macros to do what I need? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Daily Reports | Excel Discussion (Misc queries) | |||
formatting daily,weekly and monthly schedules | New Users to Excel | |||
formatting daily,weekly and monthly schedules | New Users to Excel | |||
spreadsheet for tracking reports daily, monthly, yearly and graph | Excel Worksheet Functions | |||
Collecting weekly and monthly totals from daily data | Excel Worksheet Functions |