Microsoft Office Forums - View Single Post - Consolidating Rows with same Resource Name

NoSparks · 05-30-2017, 07:38 AM

Start at the bottom of your data and work your way up the rows one at a time looking to see if the Resource Name matches the row above. If it does, add the F:NL values of the row you're looking at to the row above. Something along the lines of this

Code:

With Sheet1
    For i = LastRow To 8 Step -1
        If .Cells(i, 2).Value = .Cells(i - 1, 2).Value Then
            Set rng = .Range("F" & i & ":NL" & i)
            For Each cel In rng
                cel.Offset(-1).Value = cel.Offset(-1).Value & cel.Value
            Next cel
        End If
    Next i
End With