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

[Guest]

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 th
column
do a sort on C column
delete the surplus rows

 

[Guest]

Thanx, Bill.

Sabrina

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