Converting formula into values

[Arup C]

Hi,
Is there any process/macro by which I can convert the cells containing
formulas into values after a given period, for example I want after end of
month all the formulas will automatically convert into values. I have
workbooks of different months (sale of Jan 08, Sale of Feb 08 and so on),
which have the function TODAY, which keeps changing in the previous month's
workbook. I want them to show the last date for the particular workbook i.e.
31/01/08 for Sale of Jan 08 workbook, 29/02/08 for Sale of Feb 08 workbook.

 

[Per Jessen]

Hi

Copy / PasteSpecial > Values

Paste into the copied range and all formulas is turned into values.

Regards,
Per

 

[Arup C]

Hi Per Jessen,
I appreciate your answer it is very correct but what i asked was an
automatic process which automatically does this same procedure when the
criteria matches (End of month in my example). When the month expires the
data should automatically convert into values so that it can't change after
the month end.