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.