Copy cell from sheet2

  • Thread starter Thread starter Mukesh
  • Start date Start date
M

Mukesh

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
 
Mukesh said:
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
Click to expand...

Hi

It sounds like you need to use absolute references:

=Sheet2!$A$1

Regards,
Per
 
Back
Top