software

This is probably incredibly simple but I've been going in circles with it for
some time. I'm looking for a way to grab and hold the instantaneous value of
a cell whose contents are constantly being updated. Any thoughts?

You can quot;fixquot; the values of a cell by lt;copygt;, then select another cell
(maybe in another sheet) and Edit | Paste Special | Values | OK. This
would leave the formula in the original cell to continue to update
itself.

Hope this helps.

Petethanks for the reply. this works as a quot;manualquot; solution but how can I assign
only the contents of a cell in a formula?

quot;Petequot; wrote:

gt; You can quot;fixquot; the values of a cell by lt;copygt;, then select another cell
gt; (maybe in another sheet) and Edit | Paste Special | Values | OK. This
gt; would leave the formula in the original cell to continue to update
gt; itself.
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;
gt;