help re allocating a number over many budgets

[iwuvnumberz]

hi guys, budgeting problem here.

I want an automattic (probably involing macros and/or IF functions) way of re allocating fees across a number of budgets. different budgets have different thresholds so the 'overbudget lump some that needs to be re allocated' can't be spread evenly.

I have 9 budgets as rows (for example) and i DO know there max budget, how much is current on that buget and how much is left to be used as a number and a percentage.

Can i set up an automatic re allocation process?

http://imgur.com/wJsLIdb

the spreadsheet ^

i want the lump some in D7 to be re allocated across the cells D9 to D23 without each tranche/budget going over budget. over budget is calculated by my little on going bar chart thing which shoes a percentage. the total fee or budget size is in L 9-23. if the tranche oes over budget i want the remainder of the lump some that needs moving allocated to the following tranche and works its way down the cells D9-23. without any of them going over budget. reach 100% and move. if its already over budget obviously it should ignore that cell and look down.

i want a number to be moved over a number of different cells (directly down the column) without that cell going over a threshhold and each cell having different threshold amounts. when the first cell hits the thresh hold it should continue to move the remainder down. until the originnal number is zero ..

is that clear? :/ sorry if not.

[zbor]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-gene...y-budgets.html

Thread Closed.