Hi folks,

here is my code which looks up a piece of data from one sheet in another and clears it if it is present. (special thanks to RoyUK for the code)

Sub Rectangle18_Click()

    Dim i, j As Long
    
    For i = 4 To Sheets("Teams Used").Range("A" & Rows.Count).End(xlUp).Row
        For j = Sheets("Teams Left").Range("A" & Rows.Count).End(xlUp).Row To 1 Step -1
            If Sheets("Teams Used").Range("A" & i).Value = Sheets("Teams Left").Range("A" & j).Value Then
               Sheets("Teams left").Rows(j).ClearContents
            End If
        Next j
    Next i

End Sub
However i have lots of different colums in the sheet anmd i need it to only delete from a set colum in this case column "A" only.

please help folks

thanks for reading my thread and cheers for any help