Sub LIS(B)
ARR = Sheets(B).Range("A2:J" & Sheets(B).Range("A65536").End(3).Row)
Set D = CreateObject("scripting.dictionary")
For I = 1 To UBound(ARR)
D(ARR(I, 1)) = ARR(I, 4)
Next
K = D.KEYS
ListBox1.Clear
For I = 0 To UBound(K)
ListBox1.AddItem K(I)
ListBox1.List(I, 1) = D(K(I))
Next I
GZB = B
End Sub