EXCEL VBA Code to search cell for match to a list and delete if no match
<p>(pic link below for this example): The data starts on row "A11", one block of data is A11 to A14, I need to search that range to see if it contains a member name from a list on sheet 2, for example Erik Christensen, if the list on sheet 2 doesnt have that name I need to delete rows A11 thru A14 and continue to the next block. The list on sheet 2 will have a varying amount of members to check so that needs to be taken into consideration. Once all the rows have been processed, I need to sorth them back to start at row A11.Please see pic and I will be extremely thankful for any help.</p>

<p><a href="http://i.stack.imgur.com/3WKb7.png" rel="nofollow">Sheet 1</a></p>