Delete contents of a cell in a given range if it matches contents of a specific cell

[rcicconetti]

I am hoping for a simple solution to this problem.

I need a macro to accomplish the following:

A name is entered in cell A2. I want to use a button that will trigger a macro that will search a range J5:J50 for that same word and delete it.
i.e
This is for a scheduling sheet I am creating. The button would be "delete employee" and it should search a list (J5:J50) for the name currently in A2. Then delete the matching name(s) in (J5:J50). Then clear the name in A2 to prepare for the next entry.

[walruseggman]

Please Login or Register  to view this content.

[rcicconetti]

Awesome!!!!!!!!!!!!!!!!!!!!!!!!!!! I was googling for hours! Thanks so much!

[walruseggman]

Glad to help. Please mark this thread as solved, and any reputation points, (the star in the lower left of the posts) is appreciated.

[rcicconetti]

Oh No!!! If the cell A2 is blank, the whole thing crashes... Any Ideas?? Thanks so much!

[walruseggman]

You said the name is entered into A2... If there's nothing in A2, what name is it searching for?

[rcicconetti]

It's a scheduling program. If one of the users accidentally hits the button with no info in A1, it will hang up the program. Is there a way to have a message box appear if there is no item in A2. i.e. "Please Enter Name in Field"?

[walruseggman]

Please Login or Register  to view this content.

[jindon]

This should do

Please Login or Register  to view this content.

[rcicconetti]

The Formula works well, although if you click outside the "Please enter name" box, it gets hung up and needs to be shut down with task manager.

However, when I attempt to copy the formula, (and change the target fields) it won't work for other areas.

Please take a look at the file I attached. You'll understand what I'm talking about.

Again. Thank you so much for your assistance!!!!

Rich

[jindon]

Please Login or Register  to view this content.

[rcicconetti]

This work!