How to create a reference to a cell?

[stefanaalten]

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)"?

 

[kpark91]

Try this

=INDIRECT("'Sheet2'!A" & 32 +QUOTIENT(ROW(), 6))

 

[Joe4]

Use the INDIRECT function.

Here is one way that returns what you want from those examples you listed:

=INDIRECT("Sheet2!A" & INT(ROW()/6)+32)


Edit: Didn't see the other response while I was testing, very similar to kpark's reply.

 

[stefanaalten]

Thank you!