Option Explicit
Sub Xep()
Dim Cls As Range, Sh As Worksheet
Dim SoHo, Rws As Long
Range("B3:E" & [B65500].End(xlUp).Row).Sort Key1:=Range("B4"), Order1:=1, Key2:=Range("D4") _
, Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1
Set Sh = Sheets("Xep"): Sheets("Sheet1").Select
Sh.Cells.ClearContents
Sh.[B3].Resize(, 2).Value = [B3].Resize(, 2).Value
For Each Cls In [B3].Resize([B3].CurrentRegion.Rows.Count)
If SoHo <> Cls.Value Then
Rws = Sh.[B65500].End(xlUp).Row + 1
If Cls.Offset(, 1).Value = Cls.Offset(, 3).Value Then
Sh.Cells(Rws, "B").Value = Cls.Offset(, 1).Value
Cls.Offset(, 3).Interior.ColorIndex = 35
End If
SoHo = Cls.Value: Sh.Cells(Rws, "A") = SoHo
Else
Sh.Cells(Rws, "IV").End(xlToLeft).Offset(, 1).Value = Cls.Offset(, 1).Value
End If
Next Cls
End Sub