return amount/value under specific cell(month) based on calculation and frequency - VBA or EXCEL

[Abed89]

Hello,

i need an expert in VBA or Excel help.

i would like to return the amount (this will be coupon payment) to its due month based on start date and end date and frequency of payment.

i want to see when how much coupon payments are collected based on the timeline (monthly)

Please note that the start and end date may differ and i will have hundreds of lines

i have attached this excel for your understanding

Thank you in advance.

 

[vletm]

Abed89
... and Your expected verified results based Your sample data is ... where?

 

[Abed89]

apologies, i am attaching new file with comments.

i really appreciate your help - i've spent days on this without any clue.

Thanks,

 

[Nebu]

Hi:

May be this?

Thanks

 

[Abed89]

wow this is genius!
Thanks A million - this is really helpful!
i am gonna analyse this now