How can i copy a value in a cell from a sheet and paste in anothe.

[Guest]

Hello,

I ask my question with an exemple :

I want to copy a value in C2 from sheet1 to D5 on sheet2.
But , if i modify C2 on sheet1, D5 sheet2 has to be modified too.

Do you know the function to do that?

Thanks

( Sorry for my bad english, i speak french usually )

 

[Guest]

Try putting this in D5 on sheet2:

=Sheet2!C2

Maybe this is what you want.

Art

 

[Frank Kabel]

Hi
use the formula
='sheet1'!C2

 

[Guest]

go to cell D5 on sheet2 and hit the = key then select sheet1 and click on
cell C2 press return
what ever is in C2 sheet1 will now appear in D5 sheet2

Mark Suddes

 

[Guest]

Thanks all
It was fast.

go to cell D5 on sheet2 and hit the = key then select sheet1 and click on
cell C2 press return
what ever is in C2 sheet1 will now appear in D5 sheet2

Mark Suddes

 

[Gord Dibben]

Copy Sheet1 C2 then switch to Sheet2.

Select D5 and Paste Special>Paste Link>OK>Esc.

Your English is fine. Many having English as first language don't do as well.

Gord Dibben Excel MVP