Hi guy,

Need your help on following..

Basically i am trying to auto populate cells "with a macro" using two dates as the parameters, for example

A2 - Start Date - JAN -01-2000 ; which are inbetween Jan 2000 to DEC 2020
B2 - End Date - DEC - 31-2001 : which are in between Jan 2000 to DEC 2020
C2 - Monthly value - 99 : column C contains the value which will populated automatically under correct months
D2- Jan 00
E2 - Feb 00
F2 - Mar 00....and this carries on across till Dec 20.

What i am wanting excel to do(with macro) is to be able to populates a fixed figure "99" which is in C2 across in to the correct months, in this example.. D2 "Jan 00" to AA2 "DEC 01" .

please help on this.