Month wise allocation

[chandy123987]

I have a data starting month and ending month same qty. Attached the sample file. Need to allocation on month wise.

[PaulM100]

You can do this with basic formulas.
First of all you need to set the dates as actual month(you may format them afterwards as you desire)
Then add =IF(AND(J$2>=$F3,J$2<=$G3),$E3,"") to right and down.

[chandy123987]

yes it works well

I need macro code for that