Rather than pasting the line into the new destination, you can paste special.

Right click where you want it to go, choose paste special, then choose
"values"

Sam


"Bobby" wrote:

I have a sheet that a user inputs data in various cells. i then take this
data put in a line just using =(another cell).
i then want to copy this one line and put it into another sheet, but when i
do i get REF in all the cells i have copied. i assume this is because the
data could chang as it got from the other cell, but is there a way of doing
it?.
not explained well but if required i will attach the wb so you can see what
i mean.