Compare a value and if is true copy the line to other worksheet

[Guest]

I have in worksheet 1 a list of names in order with more data, but there's
same places without a number, like this:
1 Mary AL 6665xxx
3 Peter PT 6654xx
4 William WE 12345xx
5 Henry SD 43564x
7 Mac SD 1442554
8 Dave OP 244234
10 Hank LS 343453

What I want is to make a new worksheet with all the numbers and the lines of
the worksheet 1 with the same numbers must been copied to the new place like
this:

1 Mary AL 6665xxx
2
3 Peter PT 6654xx
4 William WE 12345xx
5 Henry SD 43564x
6
7 Mac SD 1442554
8 Dave OP 244234
9
10 Hank LS 343453

Best regards.

 

[Guest]

One way

Assume source data as posted in Sheet1, within A17

In Sheet2,
Fill the serial nos 1,2,3 ... 10 into A1:A10

Put in B1
=IF(ISNA(MATCH($A1,Sheet1!$A:$A,0)),"",INDEX(Sheet1!B:B,MATCH($A1,Sheet1!$A:$A,0)))
Copy B1 to D1, fill down to D10 to return the required results

 

[Guest]

Perfect.

I'm waiting for a big sub, and you send me a simple and quick solution.

Great!!
Thank's a lot

 

[Max]

Delighted, Florian.