Results of a Formula As a Value in New Spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

puppypants - 10 Jan 2006 20:42 GMT

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:

Signature

puppypants

Reply to this Message

JE McGimpsey - 10 Jan 2006 20:52 GMT

One way:

Edit/Paste Special, select the Values radio button.

In article <puppypants.21fs10_1136925904.5022@excelforum-nospam.com>,
puppypants <puppypants.21fs10_1136925904.5022@excelforum-nospam.com>
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!

Reply to this Message

puppypants - 10 Jan 2006 21:32 GMT

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

Signature

puppypants

Reply to this Message

Ron Coderre - 10 Jan 2006 20:53 GMT

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

Signature

Ron Coderre

Reply to this Message

bk - 11 Jan 2006 20:26 GMT

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

> Try this:
>
[quoted text clipped - 9 lines]
> Regards,
> Ron

Reply to this Message

Peo Sjoblom - 11 Jan 2006 20:30 GMT

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

Signature

Regards,

Peo Sjoblom

> paste special "values" work fine as a manual solution but how can I assign an
> instantaneous cell value as part of as formula?
[quoted text clipped - 12 lines]
> > Regards,
> > Ron

Reply to this Message

bk - 11 Jan 2006 20:56 GMT

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.

> 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
[quoted text clipped - 25 lines]
> > > View this thread:
> http://www.excelforum.com/showthread.php?threadid=499894

Reply to this Message