Results of a Formula As a Value in New Spreadsheet
 

Is there a way to take the results of a formula and simply paste the
result as a numeric value in a new spreadsheet? I have pricing that is
the result of a formula, but need to start a new spreadsheet with new
pricing that is calculated from the previous pricing. HELP!
Thanks...:confused:


--
puppypants
------------------------------------------------------------------------
puppypants's Profile: http://www.excelforum.com/member.php...o&userid=28654
View this thread: http://www.excelforum.com/showthread...hreadid=499894

Results of a Formula As a Value in New Spreadsheet
 

One way:

Edit/Paste Special, select the Values radio button.

In article ,
puppypants
wrote:

Is there a way to take the results of a formula and simply paste the
result as a numeric value in a new spreadsheet? I have pricing that is
the result of a formula, but need to start a new spreadsheet with new
pricing that is calculated from the previous pricing. HELP!

Results of a Formula As a Value in New Spreadsheet
 

Try this:

Select the source cells
EditCopy
Select the destination cell
EditPaste Special
Check: Values
Click the [OK] button

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=499894

Results of a Formula As a Value in New Spreadsheet
 

Thanks - that was the help I needed. Once again, you fine folks here
saved the day for me!


--
puppypants
------------------------------------------------------------------------
puppypants's Profile: http://www.excelforum.com/member.php...o&userid=28654
View this thread: http://www.excelforum.com/showthread...hreadid=499894

Results of a Formula As a Value in New Spreadsheet
 

paste special "values" work fine as a manual solution but how can I assign an
instantaneous cell value as part of as formula?

"Ron Coderre" wrote:


Try this:

Select the source cells
EditCopy
Select the destination cell
EditPaste Special
Check: Values
Click the [OK] button

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=499894

Results of a Formula As a Value in New Spreadsheet
 

Do you mean that when you enter the formula it will become static?
Not possible, you can trick some formulas by using iteration like in this
example

http://www.mcgimpsey.com/excel/timestamp.html

look at the "using circular reference" part, otherwise you would need code

--

Regards,

Peo Sjoblom

"bk" wrote in message
...
paste special "values" work fine as a manual solution but how can I assign
an
instantaneous cell value as part of as formula?

"Ron Coderre" wrote:


Try this:

Select the source cells
EditCopy
Select the destination cell
EditPaste Special
Check: Values
Click the [OK] button

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile:
http://www.excelforum.com/member.php...o&userid=21419
View this thread:
http://www.excelforum.com/showthread...hreadid=499894

Results of a Formula As a Value in New Spreadsheet
 

i haven't explained myself clearly. i want to interrogate a cell whose
values are constantly being updated and store that instantaneous value as a
constant elsewhere. an analogy might be storing lap times in addition to
total time.

"Peo Sjoblom" wrote:

Do you mean that when you enter the formula it will become static?
Not possible, you can trick some formulas by using iteration like in this
example

http://www.mcgimpsey.com/excel/timestamp.html

look at the "using circular reference" part, otherwise you would need code

--

Regards,

Peo Sjoblom

"bk" wrote in message
...
paste special "values" work fine as a manual solution but how can I assign
an
instantaneous cell value as part of as formula?

"Ron Coderre" wrote:


Try this:

Select the source cells
EditCopy
Select the destination cell
EditPaste Special
Check: Values
Click the [OK] button

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile:
http://www.excelforum.com/member.php...o&userid=21419
View this thread:
http://www.excelforum.com/showthread...hreadid=499894