auto fill data

  • Thread starter Thread starter terilad
  • Start date Start date
T

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
 
terilad said:
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.
Click to expand...


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.
 
Back
Top