lol. super fast response time to the private message I just sent you to enlist your help...
I had similar thoughts on how to write it- but of course was using only what I know (such as Copy & Paste). I didn't realize you save the value and then set the value to a new column. My other thought was what you had shown me previously on how to Group specific rows based on "Phase" and "Sub-Phase". Such as:
Code:
ez = Range("M1").End(xlDown).Row
Dim eStart, eEnd
eEnd = 1
Do
eStart = StartRow1(eEnd, "Phase", ez)
If eStart = 0 Then Exit Do
eEnd = EndRow1(eStart, ez)
Range(eStart & ":" & eEnd).Group
Loop
But I didn't know how to edit it for my needs.
Yes, details would be helpful.
But no, it is not obvious as to why you are doing the second look backward- hoping you could explain.