Reference Cell Step?

[chemnerd]

First off hello and thanks in advance.

My goal is to not have to manually enter every cell like this, is there something I can do to make this easier?

Sheet 1:
L17:= 'Sheet2'!G3
L33:= 'Sheet2'!G4
L49:= 'Sheet2'!G5
etc...

Sheet 2:
F3:= 'Sheet1"!Q16
F4:= 'Sheet1"!Q32
F5:= 'Sheet1"!Q48
etc...

[StephenR]

Sheet1: are you putting anything between L17 and L33? You could try
=INDIRECT("'Sheet2'!G" & 2+(ROW()-1)/16)

Sheet2:
=INDIRECT("'Sheet1'!Q" & 16*(ROW()-2))

[chemnerd]

Sheet1: are you putting anything between L17 and L33? You could try
=INDIRECT("'Sheet2'!G" & 2+(ROW()-1)/16)

Sheet2:
=INDIRECT("'Sheet1'!Q" & 16*(ROW()-2))

That worked exactly like I wanted, thank you so much. It was driving me nuts because I knew there had to be a way to do this. I hadn't thought about trying to use indirect like that.

Bravo.