Finalise "cascade" budget sheet

CANCELLED
Bids
14
Avg Bid (GBP)
£154
Project Budget (GBP)
£20 - £250

Project Description:
This assignment requires experience with Excel VBA. Please do NOT waste your bid if you cannot solve it.

I need someone to finish off the attached Excel 2010 "budget" spread sheet that has a different approach than usual.

Each month the User can select an "open ended" number of cost categories and enter limits on how much cash can be added to each category (either as a fixed sum for the month, a percentage of the total, or a limit each time the code "cycles" through the allocation),.

They then enter the funds to be placed, and the programme splits the money automatically between each category until everything has been placed. This can require several "cycles",

The output is then saved to the relevant Month on the database.

The key changes needed:
1. If a category is already at its' limit, allow the User to withdraw funds BEFORE the programme shares out the funds
2. Enable the User to recall the month and add more funds, which are then reassigned.

Any questions do not hesitate to message me.

Additional Project Description:
06/27/2013 at 5:45 EDT
To clarify some points raised by bidders:
1. There is no limit to the number of rows the User might want.
2. New rows can be added any time the file is opened.
3. Rows cannot be deleted once they are added.
4. Once a row is used for a specific cost (e.g. Rent) it must ALWAYS be used as "Rent". It cannot be changed next month to "Holidays" or something else.
5. Any criteria set in Cols C - G must be "carried down" all the following rows in the database. So when the User enters the next month date in C1 they appear automatically.
6. If the user calls up the current month, changes any criteria then saves the file, those new criteria overwrite the database from that month onward - but does NOT change previous months.
7. ALL the funds entered into C2 have to be allocated between the rows.
8. The "Overall" limit means the Closing Balance for the month being viewed cannot exceed that figure.
9. The "Monthly" limits - whether % or sum - are the amount that can be added over the ENTIRE month, NOT just the sum showing in C2.

Skills required:
Excel, Visual Basic
Additional Files: Waterfall+budget.xlsm
Hire Midlander
Project posted by:
Midlander United Kingdom
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


£ 250
in 5 days
£ 157
in 2 days
£ 180
in 3 days
£ 206
in 8 days
£ 150
in 5 days
Hire ednriu
£ 150
in 7 days
£ 80
in 5 days
Hire bharatbhatia9
£ 222
in 3 days
Hire ohenekorang
£ 150
in 3 days
Hire pentium7
£ 150
in 5 days