offset values

[glen.e.mettler]

I am pulling values from every 5th row of another worksheet. How can I
set that into the formula without doing it by hand? ie
row 5 ='Status!G30'
row 6 ='Status!G35'
row 7 = 'Status!G40'

is there a way that I can set the formula in row 6 to ='Status!G30+5
and the formula in row 7 to 'Status!G35+5

Glen

 

[Bill Kuunders]

one way

start with a series of -5 -10 and extend that down the column
highlight the range and do a find and replace
find -
replace with =Status!G
replace all

done

 

[kounoike]

One way
in row 5 =OFFSET(Status!$G$30,ROW(G1)*5-5,0)
then, drag and copy this to the range you want.

keizi

 

[Ragdyer]

Try this:

=INDEX(Status!G:G,(5*ROWS($1:1))+25)+5