Removing entries into a list from a worksheet

Tomcat14

New Member
Joined
Sep 25, 2019
Messages
2
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
BreakFrontlineBreak 1Main BreakBreak 2Remove from list
Justyna Kyrnicka14:00Easter Wisner09:0016:00
Sunita Chahal14:30Renetta Munez09:1516:15
Justin Alexis15:00Franklyn Cory09:3016:30
Lewis 15:00Lianne Tijerina09:4516:45
Michaele Clinger10:0009:00
Deandrea Halton10:1509:15
Avery Orcutt10:3009:30
Mercy Wimbish10:4509:45
Nakisha Sciortino11:0010:00
Ophelia Silguero11:1510:15
Max Mahaney11:3010:30
Eugene Lynam11:4510:45
Ricki Brite12:0011:00
Malik Sanks12:1511:15
Scotty Huddleston12:3011:30
Eusebia Bosio12:4511:45
Genoveva Mcwhite13:0012:00
Noah Woodfin13:1512:15
Margie Voight13:3012:30
Rosario Courtright13:4512:45
Earline Ridgell14:0013:00
Ying Cahall14:1513:15
Garry Aziz14:3013:30
Eldon Reider14:4513:45
Marco Verdejo15:0014:00
Bettyann Neilsen15:1514:15
Orval Sell15:3014:30
Camila Garman15:4514:45
Edith Forgione16:0015:00
Alaina Caver16:1515: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>
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Rijnsent

Well-known Member
Joined
Oct 17, 2005
Messages
1,298
Office Version
  1. 365
Platform
  1. Windows
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

Code:
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

New Member
Joined
Sep 25, 2019
Messages
2
Hi Rijnsent,

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

Watch MrExcel Video

Forum statistics

Threads
1,108,523
Messages
5,523,370
Members
409,514
Latest member
MarkZuckerberg

This Week's Hot Topics

Top