stefanaalten
Board Regular
- Joined
- Feb 1, 2011
- Messages
- 71
- Office Version
- 365
- Platform
- Windows
I must be feeling dumb
How do I create a reference to a cell, to use in a formula:
On Sheet1 I have this:
in cell A3, ='Sheet2'!A32
in cell A9 I want to display the contents of 'Sheet2'!A33
in cell A15, the contents of 'Sheet2'!A34
in cell A21, the contents of 'Sheet2'!A35
etc.
So how can I construct a reference to "sheet 2, cell A(32+x)"?
On Sheet1 I have this:
in cell A3, ='Sheet2'!A32
in cell A9 I want to display the contents of 'Sheet2'!A33
in cell A15, the contents of 'Sheet2'!A34
in cell A21, the contents of 'Sheet2'!A35
etc.
So how can I construct a reference to "sheet 2, cell A(32+x)"?