Autofill Data
 

Hi,

I am looking for a formula or code to fill in a range of cells with a figure
on the 1st of every month, so when 1st March arrives I need cell C1 to enter
£100 and when 1st April arrives I need cell D2 to £100 and so on for 12
months.

Can anyone help me with this query.

Many thanks


Mark

Autofill Data
 

Hi ,

Please try this formular in cell C1 till L1 or as need.
=IF(MONTH(TODAY())=COLUMN(C1),100,0)



"terilad" เขียน:

Hi,

I am looking for a formula or code to fill in a range of cells with a figure
on the 1st of every month, so when 1st March arrives I need cell C1 to enter
£100 and when 1st April arrives I need cell D2 to £100 and so on for 12
months.

Can anyone help me with this query.

Many thanks


Mark

Autofill Data
 

Hi,

Thats not working for me when I enter the formula even when it is before the
current date it fills in 100, any ideas?

Regards


Mark

"Lamunphan" wrote:

Hi ,

Please try this formular in cell C1 till L1 or as need.
=IF(MONTH(TODAY())=COLUMN(C1),100,0)



"terilad" เขียน:

Hi,

I am looking for a formula or code to fill in a range of cells with a figure
on the 1st of every month, so when 1st March arrives I need cell C1 to enter
£100 and when 1st April arrives I need cell D2 to £100 and so on for 12
months.

Can anyone help me with this query.

Many thanks


Mark

Autofill Data
 

Fixed it, just tweeked your code a little, took out MONTH and COLUMN and got
it working.

Thankyou for your help.

Regards


Mark

"Lamunphan" wrote:

Hi ,

Please try this formular in cell C1 till L1 or as need.
=IF(MONTH(TODAY())=COLUMN(C1),100,0)



"terilad" เขียน:

Hi,

I am looking for a formula or code to fill in a range of cells with a figure
on the 1st of every month, so when 1st March arrives I need cell C1 to enter
£100 and when 1st April arrives I need cell D2 to £100 and so on for 12
months.

Can anyone help me with this query.

Many thanks


Mark