Hello,

I was wondering whether there is a function in Excel (or if it is
possible to write a Macro) that allows you to change the formula within
a given cell to just its value (that the formula calculated), if a
certain condition is met.

For example...cells will be populated for the March coloumn from the
March data spreadsheet. As soon as March is over, the values in the
March coloumn will be fixed, and the formulas within those cells will
be disabled.


Thank you!


--
newbie101
------------------------------------------------------------------------
newbie101's Profile: http://www.excelforum.com/member.php...o&userid=37593
View this thread: http://www.excelforum.com/showthread...hreadid=572167