Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy cell from sheet2
I want to copy a cell from sheet2 to sheet1
it works fine with =Sheet2!A1, the problem is when I insert a line for new data, the data on A1 moves to A2. Now, on Sheet1 I get data of A2 instead of A1 ! Please help. Thanks. Mukesh |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy cell from sheet2
"Mukesh" skrev i meddelelsen ... I want to copy a cell from sheet2 to sheet1 it works fine with =Sheet2!A1, the problem is when I insert a line for new data, the data on A1 moves to A2. Now, on Sheet1 I get data of A2 instead of A1 ! Please help. Thanks. Mukesh Hi It sounds like you need to use absolute references: =Sheet2!$A$1 Regards, Per |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy cell from sheet2
Absolute references won't prevent the reference changing when you insert new
lines, Per. =INDIRECT("Sheet2!A1") won't change -- David Biddulph "Per Jessen" wrote in message ... "Mukesh" skrev i meddelelsen ... I want to copy a cell from sheet2 to sheet1 it works fine with =Sheet2!A1, the problem is when I insert a line for new data, the data on A1 moves to A2. Now, on Sheet1 I get data of A2 instead of A1 ! Please help. Thanks. Mukesh Hi It sounds like you need to use absolute references: =Sheet2!$A$1 Regards, Per |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy cell from sheet2
Thank you David, your formula worked.
Thanks. Mukesh "David Biddulph" wrote: Absolute references won't prevent the reference changing when you insert new lines, Per. =INDIRECT("Sheet2!A1") won't change -- David Biddulph "Per Jessen" wrote in message ... "Mukesh" skrev i meddelelsen ... I want to copy a cell from sheet2 to sheet1 it works fine with =Sheet2!A1, the problem is when I insert a line for new data, the data on A1 moves to A2. Now, on Sheet1 I get data of A2 instead of A1 ! Please help. Thanks. Mukesh Hi It sounds like you need to use absolute references: =Sheet2!$A$1 Regards, Per |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Copy data from a list in sheet1 and paste into sheet2 | Excel Discussion (Misc queries) | |||
how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ | Excel Discussion (Misc queries) | |||
Copy result from sheet1 to sheet2 | Excel Discussion (Misc queries) | |||
How do I pick the same cell in sheet 1!, Sheet2! and just drag | Excel Worksheet Functions | |||
Copy values from Sheet1 to Sheet2 | Excel Discussion (Misc queries) |