Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating a sum
I having trouble getting my macro to do what I need it to do. I have a
sheet where a user inputs data for the day it then goes to a worksheet for the corresponding day. For each day there is a budget that I have a macro that puts it in based on the day of the week. My problem is I need to total these up for the week and for the month on each page. So if it is the 1st of the month the budget for the day week and month are all the same. But on the second the week and month are added to the previous day. Then when the week is over the month will continue to accumulate but the week will be reset. I have tried recording the macro but was unsuccessful in my attempt. Thank You |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating | Excel Discussion (Misc queries) | |||
Updating | Excel Worksheet Functions | |||
DDE and updating | Excel Discussion (Misc queries) | |||
Updating an Add-in | Excel Programming | |||
When updating a worksheet, how do I create a link updating the sa. | Excel Worksheet Functions |