Use this in B1
=INDIRECT("R1C"&((ROW()-1)*6+1),FALSE)

and copy down...


"Josh Craig" wrote:

Can I create a worksheet function to say 'equals this cell reference but six
rows over'?

I want something like this:
in b1:
=a1
in b2:
=cell referenced in b1 plus 6 rows (i.e. g1)
in b3:
=cell referenced in b2 plus another 6 rows over (i.e. m1)

I'm sick of manually selecting cells!