Removing entries into a list from a worksheet

[Tomcat14]

Hi,

I have been trying to find a solution for this, searched everywhere, but cant find anything. I have a sheet with multiple colums of names. I have another sheet in the same workbook where a user enters a name/names into specified cells. Is there a way to automatically remove all the matching names entered in the specified cells from the sheet with columns of names? Any help is appreciated please.

I found some worksheet change event and calculate codes online, but cannot figure out to implement it. I want any name entered in the "Remove from list" column to be automatically deleted/taken off from the worksheet.

Thank You.

<colgroup><col style="mso-width-source:userset;mso-width-alt:12617;width:259pt" width="345"> <col style="mso-width-source:userset;mso-width-alt:3437;width:71pt" width="94"> <col style="mso-width-source:userset;mso-width-alt:12617;width:259pt" width="345"> <col style="mso-width-source:userset;mso-width-alt:3437;width:71pt" width="94"> <col style="mso-width-source:userset;mso-width-alt:3986;width:82pt" width="109"> <col style="mso-width-source:userset;mso-width-alt:3437;width:71pt" width="94"> <col style="mso-width-source:userset;mso-width-alt:3437;width:71pt" width="94"> </colgroup><tbody>
[TD="class: xl63, width: 345"]Operations
[/TD]
[TD="class: xl64, width: 94"]Break[/TD]
[TD="class: xl63, width: 345"]Frontline[/TD]
[TD="class: xl65, width: 94"]Break 1[/TD]
[TD="class: xl65, width: 109"]Main Break[/TD]
[TD="class: xl64, width: 94"]Break 2[/TD]
[TD="class: xl78, width: 94"]Remove from list
[/TD]

[TD="class: xl67"]Justyna Kyrnicka[/TD]
[TD="class: xl68"]14:00[/TD]
[TD="class: xl67"]Easter Wisner[/TD]
[TD="class: xl69"]09:00[/TD]
[TD="class: xl70"]16:00[/TD]
[TD="class: xl79"] [/TD]
[TD="class: xl81"] [/TD]

[TD="class: xl71"]Sunita Chahal[/TD]
[TD="class: xl72"]14:30[/TD]
[TD="class: xl71"]Renetta Munez[/TD]
[TD="class: xl73"]09:15[/TD]
[TD="class: xl74"]16:15[/TD]
[TD="class: xl80"] [/TD]
[TD="class: xl82"] [/TD]

[TD="class: xl71"]Justin Alexis[/TD]
[TD="class: xl72"]15:00[/TD]
[TD="class: xl71"]Franklyn Cory[/TD]
[TD="class: xl73"]09:30[/TD]
[TD="class: xl74"]16:30[/TD]
[TD="class: xl80"] [/TD]
[TD="class: xl82"] [/TD]

[TD="class: xl71"]Lewis [/TD]
[TD="class: xl72"]15:00[/TD]
[TD="class: xl71"]Lianne Tijerina[/TD]
[TD="class: xl73"]09:45[/TD]
[TD="class: xl73"]16:45[/TD]
[TD="class: xl80"] [/TD]
[TD="class: xl82"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl71"]Michaele Clinger[/TD]
[TD="class: xl69"]10:00[/TD]
[TD="class: xl69"]09:00[/TD]
[TD="class: xl80"] [/TD]
[TD="class: xl82"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl71"]Deandrea Halton[/TD]
[TD="class: xl73"]10:15[/TD]
[TD="class: xl73"]09:15[/TD]
[TD="class: xl80"] [/TD]
[TD="class: xl82"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl71"]Avery Orcutt[/TD]
[TD="class: xl73"]10:30[/TD]
[TD="class: xl73"]09:30[/TD]
[TD="class: xl80"] [/TD]
[TD="class: xl82"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl71"]Mercy Wimbish[/TD]
[TD="class: xl73"]10:45[/TD]
[TD="class: xl73"]09:45[/TD]
[TD="class: xl80"] [/TD]
[TD="class: xl82"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl71"]Nakisha Sciortino[/TD]
[TD="class: xl69"]11:00[/TD]
[TD="class: xl69"]10:00[/TD]
[TD="class: xl80"] [/TD]
[TD="class: xl83"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl71"]Ophelia Silguero[/TD]
[TD="class: xl73"]11:15[/TD]
[TD="class: xl73"]10:15[/TD]
[TD="class: xl75"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl71"]Max Mahaney[/TD]
[TD="class: xl73"]11:30[/TD]
[TD="class: xl73"]10:30[/TD]
[TD="class: xl75"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl71"]Eugene Lynam[/TD]
[TD="class: xl73"]11:45[/TD]
[TD="class: xl73"]10:45[/TD]
[TD="class: xl75"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl71"]Ricki Brite[/TD]
[TD="class: xl69"]12:00[/TD]
[TD="class: xl69"]11:00[/TD]
[TD="class: xl75"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl71"]Malik Sanks[/TD]
[TD="class: xl73"]12:15[/TD]
[TD="class: xl73"]11:15[/TD]
[TD="class: xl75"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl71"]Scotty Huddleston[/TD]
[TD="class: xl73"]12:30[/TD]
[TD="class: xl73"]11:30[/TD]
[TD="class: xl75"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl71"]Eusebia Bosio[/TD]
[TD="class: xl73"]12:45[/TD]
[TD="class: xl73"]11:45[/TD]
[TD="class: xl75"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl71"]Genoveva Mcwhite[/TD]
[TD="class: xl69"]13:00[/TD]
[TD="class: xl69"]12:00[/TD]
[TD="class: xl75"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl71"]Noah Woodfin[/TD]
[TD="class: xl73"]13:15[/TD]
[TD="class: xl73"]12:15[/TD]
[TD="class: xl75"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl71"]Margie Voight[/TD]
[TD="class: xl73"]13:30[/TD]
[TD="class: xl73"]12:30[/TD]
[TD="class: xl75"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl71"]Rosario Courtright[/TD]
[TD="class: xl73"]13:45[/TD]
[TD="class: xl73"]12:45[/TD]
[TD="class: xl75"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl71"]Earline Ridgell[/TD]
[TD="class: xl69"]14:00[/TD]
[TD="class: xl69"]13:00[/TD]
[TD="class: xl75"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl71"]Ying Cahall[/TD]
[TD="class: xl73"]14:15[/TD]
[TD="class: xl73"]13:15[/TD]
[TD="class: xl75"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl71"]Garry Aziz[/TD]
[TD="class: xl73"]14:30[/TD]
[TD="class: xl73"]13:30[/TD]
[TD="class: xl75"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl71"]Eldon Reider[/TD]
[TD="class: xl73"]14:45[/TD]
[TD="class: xl73"]13:45[/TD]
[TD="class: xl75"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl71"]Marco Verdejo[/TD]
[TD="class: xl69"]15:00[/TD]
[TD="class: xl69"]14:00[/TD]
[TD="class: xl75"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl71"]Bettyann Neilsen[/TD]
[TD="class: xl73"]15:15[/TD]
[TD="class: xl73"]14:15[/TD]
[TD="class: xl75"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl71"]Orval Sell[/TD]
[TD="class: xl73"]15:30[/TD]
[TD="class: xl73"]14:30[/TD]
[TD="class: xl75"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl71"]Camila Garman[/TD]
[TD="class: xl73"]15:45[/TD]
[TD="class: xl73"]14:45[/TD]
[TD="class: xl75"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl71"]Edith Forgione[/TD]
[TD="class: xl69"]16:00[/TD]
[TD="class: xl69"]15:00[/TD]
[TD="class: xl75"] [/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl71"]Alaina Caver[/TD]
[TD="class: xl73"]16:15[/TD]
[TD="class: xl73"]15:15[/TD]
[TD="class: xl75"] [/TD]

</tbody>

 

[Rijnsent]

Hi Tomcat,
I'm trying to get what you want:
-the user e.g. enters "Noah Woodfin", which would cause the cell with Noah Woodfin to be emptied?
-to get you started, this is a bit of code you could add to the sheet where the user types/selects the name.
-the next thing you want to do is to e.g. record a macro what the code should do, so e.g. clear the cell with that name in it

Hope this helps, if you got a bit further, please post your code here so people can help you with a next step.

Cheers,

Koen

Private Sub Worksheet_Change(ByVal Target As Range)

If Intersect(Target, Range("D7:D9")) Is Nothing Then 
	Exit Sub
else
	'Do something
	Debug.print Target.Value
	'Loop through a range on a different sheet and empty a cell?
End if

End Sub

 

[Tomcat14]

Hi Rijnsent,

Thank you for your reply. I used Scripting Dictionary to solve this. So its all good now.