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!

two ways
1. select the cell, press F2 , copy the formula from formula bar and
paste it.

2.change the reference style =IF('EAST Region PSR Detail '!A$9="","
",'EAST Region PSR
Detail '!A$9)


On Feb 9, 12:32*pm, mainsol wrote:
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!