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" <(E-Mail Removed)> wrote in message
news50D44B5-F9A6-4934-BD92-(E-Mail Removed)...
> 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.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)