Hi,
I have a range of formulas which look up values from another sheet. Once certain formulas evaluate, I would like those to be static. Is it possible to have the formula change to just the value at this point, perhaps by using a macro or some Excel function?
The only way right now I know of is to use the Paste Special option and just paste the values.
Thanks
Bookmarks