Copy cell from sheet2

[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

 

[Per Jessen]

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

 

[Mukesh]

Thank you David, your formula worked.

Thanks.
Mukesh