Formula

[antfield]

Hi

I am having an issue with the following;


In Sheet 1 D2 I insert the following ;

="Sheet2"!D2 ( which displays the Contents of the Cell in Sheet 1 D2 )

In
Sheet 1 D7 I want to add 1 to the formula to give me, the Contents of Sheet2 D3
Sheet 1 D12 would then be the contents of Sheet 2 D4 and so on

Help

 

[mfexcel]

pls be aware of the use of the double quotation.
=Sheet2!D2

Hi

="Sheet2"!D2 ( which displays the Contents of the Cell in Sheet 1 D2 )

 

[antfield]

pls be aware of the use of the double quotation.
=Sheet2!D2

Typo >: Thanks