Increase the cell name by 1

[PHolt]

Hi,

Thank you in advance.

I'm using Excel 2007. In a worksheet called May 2011, Cell B54 I have the below formula

='D-Notes by Day'!B34

In Cell C54 what I need is the vaule from
'D-Notes by Day'!B35

Is there any way I can do a formula to, Red increasing the cell number
='D-Notes by Day'!B34+1


Thank You
Pam

 

[Sektor]

=OFFSET('D-Notes by Day'!B34,1,0)

 

[VoG]

Try

=OFFSET('D-Notes by Day'!B34,1,0)

 

[GTO]

I think you could use INDIRECT, but have you considered TRANSPOSE?

 

[Roj47]

I am not sure what you are asking. Is it if you can tag symbols onto a cell reference as :

='D-Notes by Day'!B35

I am assuming this would give the result you need?

 

[Roj47]

Answers above were better than mine, so removed mine