If you want to paste the answer, rather than the formula, then use Edit/
Paste Special/ Values.

As a matter of intetrest, why did you use =sum(b8/c8) rather than just
=B8/C8? What series of numbers were you asking the SUM() function to add?
--
David Biddulph

"MWay" wrote in message
...
How do I move formulated data from one worksheet to another? I have a
master
worksheet that uses simple formuals such as =sum(b8/c8) and I want to take
the answer and apply it to a diffrent worksheet in the same work book but
I
get the #REF! error.