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.

Operations	Break	Frontline	Break 1	Main Break	Break 2	Remove from list
Justyna Kyrnicka	14:00	Easter Wisner	09:00	16:00
Sunita Chahal	14:30	Renetta Munez	09:15	16:15
Justin Alexis	15:00	Franklyn Cory	09:30	16:30
Lewis	15:00	Lianne Tijerina	09:45	16:45
		Michaele Clinger	10:00	09:00
		Deandrea Halton	10:15	09:15
		Avery Orcutt	10:30	09:30
		Mercy Wimbish	10:45	09:45
		Nakisha Sciortino	11:00	10:00
		Ophelia Silguero	11:15	10:15
		Max Mahaney	11:30	10:30
		Eugene Lynam	11:45	10:45
		Ricki Brite	12:00	11:00
		Malik Sanks	12:15	11:15
		Scotty Huddleston	12:30	11:30
		Eusebia Bosio	12:45	11:45
		Genoveva Mcwhite	13:00	12:00
		Noah Woodfin	13:15	12:15
		Margie Voight	13:30	12:30
		Rosario Courtright	13:45	12:45
		Earline Ridgell	14:00	13:00
		Ying Cahall	14:15	13:15
		Garry Aziz	14:30	13:30
		Eldon Reider	14:45	13:45
		Marco Verdejo	15:00	14:00
		Bettyann Neilsen	15:15	14:15
		Orval Sell	15:30	14:30
		Camila Garman	15:45	14:45
		Edith Forgione	16:00	15:00
		Alaina Caver	16:15	15:15

<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>
</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.