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

S

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
 
B

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
 
S

Sabrina

Thanx, Bill.

Sabrina

bill k said:
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
Click to expand...
 
Top