Converting formula into values
 

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.

Converting formula into values
 

Hi

Copy / PasteSpecial Values

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

Regards,
Per

"Arup C" skrev i meddelelsen
...
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.

Converting formula into values
 

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.

"Per Jessen" wrote:

Hi

Copy / PasteSpecial Values

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

Regards,
Per

"Arup C" skrev i meddelelsen
...
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.