How to Clear a Cell Based On Another Cell

[CHHeights]

Hello!

I am very new to Excel so please bear with me on explaining this.

I am trying to clear a cell based on the a change to another cell. I wish to do this for each cell. What I mean is, in column G I have dates. and I want to be able to clear that date anytime I input data into the adjacent cell.
For instance:
G25 has : 1/2/2022
I want that to clear whenever I put data in cell H:25
I would like this to happen for the rest of the columns.

Is there anyway I can do this?

I know many people have said use a VBA code but I haven't found any for my specific needs.

Thanks so much in advance. Sorry if this isn't clear.

 

[Joe4]

Welcome to the Board!

Right-click on the sheet tab name at the bottom of your screen, select "View Code", and paste this code in the resulting VB Editor window that pops up.

Private Sub Worksheet_Change(ByVal Target As Range)

    If Target.CountLarge > 1 Then Exit Sub
   
    If (Target.Column = 8) And (Target <> "") Then
        Target.Offset(0, -1).ClearContents
    End If

End Sub

Now, whenever you make a non-blank entry in column H, it will clear column G of that same row.

I would like this to happen for the rest of the columns.

If you want help with this part, you need to tell us EXACTLY which columns you are talking about.
We already know about the G/H pair, now what other columns do you want to apply this to?

 

[CHHeights]

Welcome to the Board!

Right-click on the sheet tab name at the bottom of your screen, select "View Code", and paste this code in the resulting VB Editor window that pops up.

Private Sub Worksheet_Change(ByVal Target As Range)

    If Target.CountLarge > 1 Then Exit Sub
  
    If (Target.Column = 8) And (Target <> "") Then
        Target.Offset(0, -1).ClearContents
    End If

End Sub

Now, whenever you make a non-blank entry in column H, it will clear column G of that same row.


If you want help with this part, you need to tell us EXACTLY which columns you are talking about.
We already know about the G/H pair, now what other columns do you want to apply this to?

Hi! Thank you so so much! This worked perfectly. I also realized I wrote columns when I meant rows, and you answered my question perfectly. Thank you so so much again. I really appreciate it!

 

[Joe4]

You are welcome.
Glad I was able to help.