Refrencing cell formulas in a new worksheet
 

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.

Refrencing cell formulas in a new worksheet
 

First, you don't need =sum() in your formula:
=b8/c8
is sufficient

Second, I'm assuming that you're copying the cell and pasting it into the second
worksheet.

Excel will adjust the formula so that the references will be in the same
relative location to the cell with the formula.

An easier example.

Put =A1
in B2

Then copy B2 and paste into J14 (say). The formula adjusts to =I13 (one cell up
and one cell to the left).

The same thing will happen with your formula. So you could be pasting into a
location that doesn't have a cell that's in the same relative location.

If you put =a1 in B2 and the copy B2 and paste into D1, there is no cell
directly above it--so you see a #ref! error.

You have a few alternatives...

1. If you want the formula to be =b8/c8, you can copy from the formula bar--not
from the cell itself and paste into the formulabar in the other cell.

2. You could change the original formula to =$b$8/$c$8
This formula won't adjust when you paste it anywhere else.

Take a look at Excel's help for "About cell and range references" to see more
information about "The difference between relative and absolute references".

MWay wrote:

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.

--

Dave Peterson

Refrencing cell formulas in a new worksheet
 

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.