Results of a Formula As a Value in New Spreadsheet

  • Thread starter Thread starter puppypants
  • Start date Start date
P

puppypants

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:
 
Try this:

Select the source cells
Edit>Copy
Select the destination cell
Edit>Paste Special>
Check: Values
Click the [OK] button

Does that help?

Regards,
Ron
 
Thanks - that was the help I needed. Once again, you fine folks here
saved the day for me!
 
paste special "values" work fine as a manual solution but how can I assign an
instantaneous cell value as part of as formula?
 
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 said:
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 said:
Try this:

Select the source cells
Edit>Copy
Select the destination cell
Edit>Paste Special>
Check: Values
Click the [OK] button

Does that help?

Regards,
Ron
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
Try this:

Select the source cells
Edit>Copy
Select the destination cell
Edit>Paste Special>
Check: Values
Click the [OK] button

Does that help?

Regards,
Ron
Click to expand...
Click to expand...
Click to expand...
 
Back
Top