Hi!

I am looking for a way to work smarter..! I am wondering how to copy a
formula to the cell below but change the reference in the formula at the same
time.

For example; =IF('EAST Region PSR Detail '!A9=""," ",'EAST Region PSR
Detail '!A9)
if you drag this down to the cell below, the cell reference will change from
A9 to A10. I am looking to get it to change in intervals of 6 instead of 1.
So the cell below would be A15 instead of A10.

Thank you!