Fill up capacity over weeks

[TrickY101]

Hi,

I have:
- a max capacity per week
- assignments todo per area
- assignments todo in different buckets

I want to fill each week till its max capacity starting in area1 and moving down the list.

When the weeks maximum capacity is reached it needs to move on to de next week and keep moving down de area list.

When the assignments in todo1 are fully assigned, start with todo2 from the top of the area list.



I tried writing something of a formula, but the if/then nesting gets a little out of hand. So I'm thinking a macro could do the trick, but i can't write it myself.

Some help in writing the code or push me in the right direction is much appreciated!
Thanks in advance!