Consolidating Rows with same Resource Name

[OTPM]

Hi Folks
I am in the process of writing an Excel Capacity Management Tool and am looking for help in combining rows where the Resource Name is the same as the previous row.
For example in the sample attached is row 8 has the same Resource Name as row 7 then I want to merge the values from Columns F to NL into row 7 and do the same for each row on the worksheet.
Note that columns F to NL are calculated based on the dates in columns "C". I intend to remove all formulas from columns F:NL before I run the routine to consolidate the rows.
I am struggling with the code for this so any help/advice would be appreciated.


Thanks in anticipation.
Tony

[NoSparks]

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

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

[OTPM]

Hi
Many thanks for your prompt response.
I will give that a go tomorrow.
Kind regards
Tony