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

1) Select and Copy the cells
2) With cells still selected, use Edit | Paste Special with Values checked.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"newbie101" wrote
in message ...

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