Moving data to another sheet
 

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.

Moving data to another sheet
 

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.