How to allocate amount based on Payment Start Date and End Date thru VBA

[aaleem]

Hi,

I'm using a formula to allocate the amount evenly based on the frequency of payment, due to numerous projects it is quite difficult to change the reference for each project, how we can achieve the same through VBA. The results are in column G to J.