IF CELL IS ONE FROM A LIST, CLEAR ADJACENT CELL

[turkanet]

Dear friends,
I have a list in N2:N. I need to clear cell contents in rows of B2:B if row in C2:C is in N2:N
e.g.: if C4 exist in N2:N (matching completely, not partly), then B4 cell content must be cleared.

thank you in advance

 

[dreid1011]

Dreid,
it happens when the user presses a button or runs the code

Thank you. Give this a try:

Private Sub ClearB()
Dim c As Range, listN As Range

Set listN = Range("N2", Range("N" & Rows.Count).End(xlUp))

For Each c In Range("C2", Range("C" & Rows.Count).End(xlUp))
    If IsNumeric(Application.Match(c.Value, listN, 0)) Then
        Range("B" & c.Row).ClearContents
    End If
Next c
End Sub

If you want it attached to a button, add the code to a standard module, insert a form button and assign the macro as "ClearB".

 

[turkanet]

Thank you very much Dreid. Works fine..

 

[dreid1011]

Thank you very much Dreid. Works fine..

You're welcome, and happy to help.