Pop-up message if value for sum of cells exceeds a predefined number - Multiple sums

Hello,

I have posted a couple of days ago the same question and @xladept helped me out with this VBA code. (Link to initial thread - https://www.excelforum.com/excel-pro...ed-number.html)

The problem i am now facing is the fact that i would like to have the same code upgraded for the sum of multiple months, not just one.

So we have the following information:

- months sheet - columns E and F show the months for the sums (for example the sum for each row in the DATA sheet coresponding to month January to April should not exceed 105, for months Febraury to May should not exceed 105 and so on)

- DATA sheet - for each name in the B column, the sum mentioned above will be calculated between the months that are in the H:NH columns.

Below you can find the attached document along with the code from @xladept.

Please Login or Register  to view this content.

bump .... 123

Hello xladept.

It is true, i have nothing planned for next year.

The thing is that i will use the document for the next years by changing the dates from the DATA sheet.

And you are correct regarding the months, i wrote them wrong. Changed the document please find attached.

Although i don`t have anything planned for them 4 months in the 2019 year the sum from 1-Oct-18 to 31-Jan-18 should only be calculated between 1-Oct-18 to 31-Dec-18, the sum of 1-Nov-18 to 28-Feb-19 should only be calculated between 1-Nov-18 to 31-Dec-18 and so on.

Thanks,
-Alex