Loop and Check For Values In Entire Column in Excel

[Jeff5019]

I need this to check every cell in these columns. Not just the cells in row 2. Any assistance would be greatly appreciated.

If Sheets("RSL").Range("M2") = Sheets("FailedSpots").Range("L2") Then

    If Sheets("RSL").Range("K2") > Sheets("FailedSpots").Range("M2") Then
    
        Sheets("RSL").Range("K2").Value = Sheets("FailedSpots").Range("M2").Value
        
    End If
    
End If

[Admin]

Hi Jeff5019

Welcome to ExcelFox !!

add code tags while posting codes

[Admin]

Hi

try

Sub kTest()

    Dim LastRow     As Long, i As Long
    Dim RSL_Data, FS_Data, r As Range
    
    With Sheets("RSL")
        LastRow = .Range("m" & .Rows.Count).End(xlUp).Row
        Set r = .Range("k2:m" & LastRow)
        RSL_Data = r.Value2
    End With
    
    With Sheets("FailedSpots")
        LastRow = .Range("m" & .Rows.Count).End(xlUp).Row
        FS_Data = .Range("l2:m" & LastRow)
    End With
        
    
    For i = 1 To LastRow - 1
        If RSL_Data(i, 3) = FS_Data(i, 1) Then
            If RSL_Data(i, 1) > FS_Data(i, 2) Then
                RSL_Data(i, 1) = FS_Data(i, 2)
            End If
        End If
    Next
    
    r = RSL_Data

End Sub

[Excel Fox]

Added a more generic thread title. Jeff, for posterity and for the sake of people searching for similar queries in Excel, it would be best to provide a thread title that describes the objective in a more concise manner.