I designed a macro that is working fine thanks to your and others help.
Thanks again.
--
rbane


"Pete" wrote:

If the cells that you want the (daily) answer in are all in the same
row or column, then it is easy enough to just highlight that row
(/column) then copy the formulae to the next row (/column), and then
fix the data in "today's" row (/column). This way the operations take
place on a range of cells and it will take no longer to achieve this
than to do it for one cell. Obviously, you will have the changes to
make to several cells in column A, unless you copy/paste that from
somewhere else.

Hope this helps.

Pete