Automatically delete cell contents if 1 cell deleted

Hi,

You'll need to resort to VBA and a macro. Assuming your Last Name column is say column B, and you want to delete the contents of say columns G & J on the same row as a Last Name deletion, then

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Not Intersect (Target, Range("B:B") Is Nothing Then

Range("G" & Activecell.Row ",J" & ActiveCell.Row).ClearContents

End If

Expand the instruction inside the If statement to include other columns.

HTH

End Sub

Thanks Richard, I think that will work![/SIZE]