instantaneous cell value

bk · January 10th, 2006, 12:11 AM posted to microsoft.public.excel.newusers

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?

Pete · January 10th, 2006, 12:40 AM posted to microsoft.public.excel.newusers

You can "fix" the values of a cell by copy, 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.

Pete

bk · January 10th, 2006, 08:06 PM posted to microsoft.public.excel.newusers

thanks for the reply. this works as a "manual" solution but how can I assign
only the contents of a cell in a formula?

"Pete" wrote:

You can "fix" the values of a cell by copy, 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.

Pete

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Possible Lookup Table	Karen	Worksheet Functions	5	June 8th, 2005 09:43 PM
Copy cell format to cell on another worksht and update automatical	kevinm	Worksheet Functions	21	May 19th, 2005 11:07 AM
Changing Cell References	Katrina	Worksheet Functions	1	September 22nd, 2004 05:37 PM
Do you have what it takes...	Frank Kabel	Worksheet Functions	1	February 22nd, 2004 08:30 PM
Conditional Formating on value of cell and prev cell	Phillips	Worksheet Functions	2	December 3rd, 2003 11:27 PM