offset values

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

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


--
Greetings from New Zealand
Bill K
<glen.e.mettler@lmco.com> wrote in message
news:1144183803.513870.120820@t31g2000cwb.googlegroups.com...
>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
>

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

<glen.e.mettler@lmco.com> wrote in message
news:1144183803.513870.120820@t31g2000cwb.googlegroups.com...
> 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
>

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
<glen.e.mettler@lmco.com> wrote in message
news:1144183803.513870.120820@t31g2000cwb.googlegroups.com...
> 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
>