How can I use fill hand to copy the fomula in this case?

[Sabrina]

Here is my fomula:
B1: =sheet2!A1
B2: =sheet2!A4
B3: =sheet2!A7
B4: =sheet2!A11
.........

Is it possible to use fill handle to copy the fomula automatically in my
case?, If so, how? Thanks.

Sabrina

[bill k]

I assume that B4 should read = sheet2!A10

with a help column in sheet1
enter the first function in B1 and fill that down the column
enter in C column a series of 1<><>2<><>3<><>and extend that down the column
do a sort on C column
delete the surplus rows

Here is my fomula:
B1: =sheet2!A1
B2: =sheet2!A4
B3: =sheet2!A7
B4: =sheet2!A11
.........

Is it possible to use fill handle to copy the fomula automatically in my
case?, If so, how? Thanks.

Sabrina

[Sabrina]

Thanx, Bill.

Sabrina

"bill k" wrote:

>
> I assume that B4 should read = sheet2!A10
>
> with a help column in sheet1
> enter the first function in B1 and fill that down the column
> enter in C column a series of 1<><>2<><>3<><>and extend that down the
> column
> do a sort on C column
> delete the surplus rows
>
>
>
> Sabrina Wrote:
> > Here is my fomula:
> > B1: =sheet2!A1
> > B2: =sheet2!A4
> > B3: =sheet2!A7
> > B4: =sheet2!A11
> > .........
> >
> > Is it possible to use fill handle to copy the fomula automatically in
> > my
> > case?, If so, how? Thanks.
> >
> > Sabrina
>
>
> --
> bill k
>
>
> ------------------------------------------------------------------------
> bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
> View this thread: http://www.excelforum.com/showthread...hreadid=400604
>
>