Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
moving data from one sheet to another | Excel Discussion (Misc queries) | |||
Moving data from one sheet to another | Excel Discussion (Misc queries) | |||
moving certain data to another sheet. | Excel Programming | |||
Moving data to another Sheet | Excel Programming | |||
moving data from one sheet to another | Excel Discussion (Misc queries) |