Moving data to another sheet

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.
 
S

Sam Wilson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top