Is there a reason why all the data is in one column? Makes filtering harder.
So I've ignored your format and assumed it should be e.g.
Make | Model
___________
Ford | Focus
Ford | Fiesta
BMW | 318
VW | Golf
VW | Polo
(And there's probably a much nicer way of doing this as well...)
Private Sub lst1_Change()
On Error Resume Next
lst2.Clear
With Sheets("sheet2").UsedRange
.AutoFilter
.AutoFilter Field:=1, Criteria1:=lst1.Column(1)
For Each c In .Offset(1, 1).Resize(.Rows.Count - 1, 1).SpecialCells(xlCellTypeVisible)
lst2.AddItem c.Text
Next
End With
End Sub