enter $ amount automatically by date

  • Thread starter Thread starter Dave M
  • Start date Start date
D

Dave M

I am interested in entering $ amounts in an excel
spreadsheet automatically on certain dates of the month.
I currently have to type the amounts in.
 
I can see that Dave, I would be interested to see a program do my work as
well <g>.

But serious, ths is very little information to work with. What are these
amount you want to see typed in ?. Where should they be entered ?
How could the program decide when to enter them ?
In which file ? Do you open these file or should they automaticly be
enterd even if they aren't opened ?

And so on, and so on ....

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
This might be possible with a formula that checks the date

=if(now()>dateValue("05/13/2004"),100,"")


or if more complex, perhaps with a macro.
 
this will give you references, from where you can enter a default value.

=IF(NOW()>=DATE(A5,'End-Year-04'!G28,1),E87,0)

hope that helps..
 
Back
Top