Extracting a Value from a formula

[dai534071]

Hello,

I am calculating a range of results and I'd like to extract the values calculated and put them into a seperate spreadsheet then re-use to formulas to calculate my next set of results. Obviously copy+pasting from my formulas just copies the original formula and not the result of it. Is there a way around this?

Thanks in advance.
Dai

[RHCPgergo]

Try using copy --> paste special (values only).
http://www.dummies.com/how-to/conten...xcel-2010.html

[:) Sixthsense :)]

Once you have done the copy then move to the desired cell and press ALT+E+S+V and click Ok....