Here's a simple procedure that you can use
In Sheet2,
Put in F7: =IF(E7="","",IF(COUNTIF(Sheet1!$B$4:$B$100,E7),"","x"))
Copy down to F100 to flag the cases as "x"
Apply Filter on F6:F100, choose: "x", then copy the filtered cells n paste special as values into Sheet1 col B
Clean up by deleting F7:F100. Done.
--------------------------------
Success? Wave it, whack the little star at the bottom left of my response