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

C

clapton

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 )
 
S

Suddes

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
 
C

clapton

Thanks all :)
It was fast.

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

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
 
Top