Thread: Copy in order
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Copy in order

Hi,

You could just sort sheet1 by Col A.
Or if you don't want to do that,
In the cell B2 (next to 101) on sheet2, enter
=IF(ISNA(VLOOKUP(A2,Sheet1!$A$2:$B$10,2,0)),"",VLO OKUP(A2,Sheet1!$A$2:$B$10,2,0))
Then copy down.

I have assumed that your data starts on Row 2, and is in Cols A and B
Change the Range to suit your data.

Regards - Dave.