So this problem might be a bit complicated and I have been trying to concieve of ways to orchestrate a solution to this issue and have come up blank.
Essentially, every week on Monday my branch managers report a specific number to me. It can be realistically any number. And its given a time stamp of when the number is filed. For example,
02/03/19 4
xx/xx/xx 2
xx/xx/xx 3
xx/xx/xx 0
Now I have these data points listing every week till 2015, so yeah lots of data. The issue is I am tryin to create a macro that checks for all the data stamped within a specific month and then summing all that data together into a seperate cell. Currently I am doing this by hand and I just want a way to automate it. I dont want it adding the data together until an entire month has passed so if I click the macro button, if a full new month hasnt passed then it does nothing. However, if a full month has passed then it sums up the data points from that month and sums them into a new cell. I would just create a macro that sums the last four data points and click it at the begining of every month except some months of the year have 5ish weeks in them and it screws with the 4 point system so I am at an impasse.
The desired result would yield data that looks like this, taken from the individual weeks reported above.
4/19 13
5/19 14
6/19 21
and the new month would go at the bottom of this above column with the new summed data and time stamp.
This is beyond my excel skills so any help would be greatly appreciated! Thank you!
Essentially, every week on Monday my branch managers report a specific number to me. It can be realistically any number. And its given a time stamp of when the number is filed. For example,
02/03/19 4
xx/xx/xx 2
xx/xx/xx 3
xx/xx/xx 0
Now I have these data points listing every week till 2015, so yeah lots of data. The issue is I am tryin to create a macro that checks for all the data stamped within a specific month and then summing all that data together into a seperate cell. Currently I am doing this by hand and I just want a way to automate it. I dont want it adding the data together until an entire month has passed so if I click the macro button, if a full new month hasnt passed then it does nothing. However, if a full month has passed then it sums up the data points from that month and sums them into a new cell. I would just create a macro that sums the last four data points and click it at the begining of every month except some months of the year have 5ish weeks in them and it screws with the 4 point system so I am at an impasse.
The desired result would yield data that looks like this, taken from the individual weeks reported above.
4/19 13
5/19 14
6/19 21
and the new month would go at the bottom of this above column with the new summed data and time stamp.
This is beyond my excel skills so any help would be greatly appreciated! Thank you!
