Moving data to another sheet

  • Thread starter Thread starter Bobby
  • Start date Start date
B

Bobby

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.
 
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
 
Back
Top