Might help if you copy/paste an example of your formula. Do NOT send
attachment.

--
Don Guillett
SalesAid Software

"Shane" wrote in message
...
Hi Guys, got a problem here that hope you can solve


Currently, i have to update my database formulas monthly

What is currently happening is that i entered a formula
to read data from a monthly source file.

So, at every month end, i have to change the formula
manually so that the new month's source data could be
read.

Is there anyway to create a formula or a Macros so that i
do not have to update all the formulas manually, but
rather, by pressing the Macros icon,or by some other
means, the formulas can be updated?

Pls help
Thanks