Macro to clear contents of cell two columns along in the same row if value changes

[cutleryhands]

Hi All

So, I have dates in column A and dates in column C.

I need C to be cleared in the event A is changed.

I also need this to work all rows. I have been trying for a few days copying other solutions that look close and jave been trying to learn aswell but I need this quicker than I appear to be able to figure it out myself.

Any help would be appreciated.

Cutlery....

 

[dreid1011]

Welcome to the board.

Here is a basic worksheet_change event code that will clear the contents of specific row in Col C if the same row value in Col A changes. Now, this is just the starting piece and you will have to make additions to this so it doesn't just clear Col C because you clicked in a cell to edit in Col A.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A:A")) Is Nothing Then
    Range("C" & Target.Row).Clear
End If
End Sub

 

[cutleryhands]

Many thanks Dreid.

I am getting some joy but wondered, I have it working for manually changing or deleting the cell value.

However, if the value in A is linked and changed via the linked workbook then it does not clear the value in row C ?

Cutlery

 

[dreid1011]

I'll have to look into that.