auto fill data

[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

 

[Dirk Goldgar]

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.

This sounds like an Excel question, whereas this forum is devoted to
questions about programming Microsoft Access. I imagine that you can get
your question answered more readily in one of the Excel groups.