copying formulas

  • Thread starter Thread starter mainsol
  • Start date Start date
M

mainsol

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)
 
Back
Top