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

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Rijnsent

Well-known Member
Joined
Oct 17, 2005
Messages
1,300
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,127,973
Messages
5,627,942
Members
416,282
Latest member
fchagas97

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top