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.