Auto Filling Monthly Savings for Current Year and Carry Over Years by Date

[Neavalmi]

Dear Excel Gurus/Experts:

Need your help for this worksheet.
I am in charge of calculating the savings per project. Our savings is to be captured for 12 months per project.
Currently i am doing a manual entering of monthly savings per month by dividing the "full year savings" by 12 and manually enter the monthly savings per bucket.

I would really appreciate if you can help me automate this process when i enter the Date of implementation and the full year savings.

I have provided some examples below with different scenarios.

TinyUpload.com - best file hosting solution, with no limits, totaly free

Please note that savings capturing is to start after two (2) months of implementation date.

Many thanks in advance.

 

[Neavalmi]

Probably my question is not challenging enough for our experts here but it is for me and i hope someone is really kind enough to share their knowledge. If the presentation of my problem is not clear or you need questions please let me know as i am not a native english speaker so i dont know how to write good english. sorry.

 

[Neavalmi]

Hello Guys ,

Are there no one here who can help?

 

[Neavalmi]

i am loosing confidence on the members here...even any comments at all, there's nothing!

I may just go to other forums instead where members are more willing to help.