Auto Populating Cells From A Date Range

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.

Please Login or Register  to view this content.

hi, vuyyuru, will that be of any help?

Originally Posted by Bob Phillips

Please Login or Register  to view this content.

Hi Bob,

Thanks for your help. your macro almost helps. the only change i need is ..

the columns are fixed, that means column-D is for Jan-00, E is for Feb-00 , F is for MAR-00.......
for example if start date is Jan -01 -2000 (A2 value) and end date is DEC- 31-2000 (b2 value) the value of column C2 will populate in column D2 to O2.

if start date is Jan -01 -2001 (A2 value) and end date is NOV- 30-2001 (b2 value) the value of column C2 will populate in column P2 to Z2.

please help on this.

Originally Posted by watersev

hi, vuyyuru, will that be of any help?

wow! your formula is good. but why if not populating the value under the month MAR-00? for the date rage (Jan-01-2000 to DEC-31-2001). please check on this and the column headings need to present in row 1 insted of row2. i changed your fomula from "=IF(AND(A2>=$D$2,D2<=$B$2),$C$2,"")" TO "=IF(AND(A2>=$D$1,D1<=$B$2),$C$2,"") " .. It's not working ? i'm not sure what mistake i done?

Originally Posted by vuyyuru

wow! your formula is good. but why if not populating the value under the month MAR-00? for the date rage (Jan-01-2000 to DEC-31-2001). please check on this and the column headings need to present in row 1 insted of row2. i changed your fomula from "=IF(AND(A2>=$D$2,D2<=$B$2),$C$2,"")" TO "=IF(AND(A2>=$D$1,D1<=$B$2),$C$2,"") " .. It's not working ? i'm not sure what mistake i done?

Hi, thanks.. i'm able to correct the formula, i changed to =IF(AND(D1>=$A$2,D1<=$B$2),$C$2,"") .. it's working fine. thanks for the help. i mainly looking for a macro solution, i will wait for Bob or other reply. thanks for you support too. i learned a new thing from you today.

Is this what you mean

Please Login or Register  to view this content.

Originally Posted by Bob Phillips

Is this what you mean

Please Login or Register  to view this content.

Perfect.. this is what I’m looking for. Super Bob!. Thank you very much.