offset values

G

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
 
B

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
 
K

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
 
Top