View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Florian Florian is offline
external usenet poster
 
Posts: 1
Default Compare a value and if is true copy the line to other worksheet

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.