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