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.
Bookmarks