Consolidating Rows with same Resource Name

NoSparks · #2 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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Consolidating various word docs in one	Max Downham	Word	6	11-23-2015 05:07 PM
Need help consolidating data from separate sheets	tiwas	Excel	1	10-07-2014 04:57 AM
Consolidating Sentences into One Paragraph	ctsolar	Word	4	12-16-2013 04:50 PM
Consolidating data using Macro	mrjamez	Excel Programming	2	05-22-2012 06:50 AM
Help with consolidating multiple records into one	wbiggs2	Excel	0	11-30-2006 01:02 PM