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

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

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

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