Hi,

Thanks for the reply!

Is there any excel code that allows me to do that? If not any idea how do I
write the macro code for this function?

Thanks!



"FSt1" wrote:

hi
no such formula exists. formulas return values, they can not perform actions
such as copy, past or covert itself to hard values when a conditions is met.
to do this requires code, either built in excel code (mouse and keyboard
caused excel code to run) or user defined add on code i.e. a macro.

regards
FSt1

"Lim" wrote:

Hi,

I need help to know whether there is a formulae which I can paste value
after doing an average calculation.

For example the cell will calculate the average of a series of numbers and
will paste value when the specify date is reached.

I do not wish to use a macro function, thanks!