Convert function to absolute value?
Posted by jimbo on May 03, 2000 3:07 PM
after updating data daily using index/match, I then need to convert the cells to the linked value so that on subsequent days the function is not re-applied
i.e. how do you convert a function to an absolute value derived from the function?
Posted by Ivan Moala on May 03, 2000 5:44 PM
Jimbo
You can do this via VBA and the sheet calculate
event handler set up to a linked cell date so that if todays date exceeds a certain date it will
place values in the formula cells BUT
probably the easiest is to just select the relevent
cells and to a Copy/Pastespecial/values.
Ivan
