Removing text from one cell if removed in another

Hi lifeline
Welcome to the forum

You will need to use the WorksheetChange Event to do this.

1/. Right click on the sheet tab and click View Code. This will open the VBa Editor and take you to the correct module for that sheet.

2/. Paste all of this code in the resultant pane.

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$B$2" Then
        If Target = "" Then Range("A1") = ""
    End If
End Sub

Hope this helps