• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

Abed89

New Member
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.
 

Attachments

  • Book1.xlsx
    11.1 KB · Views: 1
apologies, i am attaching new file with comments.

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

Thanks,
 

Attachments

  • Book1.xlsx
    12.3 KB · Views: 2
Back
Top