Extract Multi-line data and date comparison

A demonstration as a starter :

PHP Code: 

Sub Demo1()
    Dim R&, V, D$(1), S$(1)
        Application.ScreenUpdating = False
    For R = 2 To ActiveSheet.UsedRange.Rows.Count
        For Each V In Split(Replace(Cells(R, 1).Value, vbCr, ""), vbLf)
                 V = Split(V, ";")
              V(1) = Split(V(1), "=")(1)
            If V(1) > D(0) Then
                D(0) = V(1)
                S(0) = V(0)
            ElseIf V(1) = D(0) Then
                S(0) = S(0) & vbLf & V(0)
            End If
            If V(1) < D(1) Or D(1) = "" Then
                D(1) = V(1)
                S(1) = V(0)
            ElseIf V(1) = D(1) Then
                S(1) = S(1) & vbLf & V(0)
            End If
        Next
            Cells(R, 2).Resize(, 2).Value = S
            Erase D, S
    Next
        Application.ScreenUpdating = True
End Sub 


Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

Absolutely Perfect and works like a charm.

but little query can we have loop for either of new columns when, generated cell is empty text written in say COLUMN HEADER => product ... respective cell content is copied.

many thanks for above vba solution