passing values to other sheets

[kaja48380]

hi i am having the integer values in the column of h2 in sheet1 i like
to have the same value in column of d56 in sheet2

 

[Gord Dibben]

In D56 enter =Sheet1!H2


Gord Dibben MS Excel MVP