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.

One way

Assume source data as posted in Sheet1, within A1:D7

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(Sheet 1!B:B,MATCH($A1,Sheet1!$A:$A,0)))
Copy B1 to D1, fill down to D10 to return the required results
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


"Florian" wrote:

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.

Delighted, Florian.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Florian" wrote in message
...
Perfect.

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

Great!!
Thank's a lot