Filling in a set number of cells after a given date

Ok,this is a slightly funny one! I've got a list of data which is a date (DD/MM/YYYY), a monetary value and a numerical value. Following that I've got blank columns representing the months. I need a formula that will look at the date, find the month *after* the month of that date, and then fill in the monetary value in the appropriate number of cells after that.

So I've got:
Date Amt Value Jan-12 Feb-12 March-12 Apr-12 May-12 and so on...
01/03/2012 £10 12

What I need is:

Date
Date Amt Value Jan-12 Feb-12 March-12 Apr-12 May-12 and so on...
01/03/2012 £10 12 £10 £10 and so on for 12 months.

the £10 values in the second example should be under April, May etc.

Is that something that's possible?

hi Aileanor, assuming the formula for Jan-12 is in D2, try:
=IF(AND(DATE(YEAR($A$2),MONTH($A$2),1)<D1,COUNT($C$2:C2)<$C$2+1),$B$2,"")