I tried (unsuccessfully) to write a piece of code that will allow me to have my numbers totaled each month instead of just continuously.
I'm thinking of 2 ways to do this. The first would be what I attempted above where when column B has a date that is the first of the month, it will clear the totals that have summed down from the month before, and then will be available for new data to be input.
The second would be something along the lines of just subtracting the previous month’s totals from the current month and having them store somewhere.
Any ideas on how VBA could be utilized for this? Thanks for any help.