This is a tricky one

[gymbag]

Does anybody else have any ideas for this problem

 

[Guest]

let'ssay you want to display the cell value of D28 on sheet2 in the cell A26
of this sheet:
1-click the cell A26
2-give the formula like this : =sheet2!D28

or
1-click the cell A26
2-type = and then activate sheet2 and click on cell D28
3-press Enter

just like that!