List and filter in a listbox

[kryt0n]

Hi all,

So I have a sheet with a list of names and tasks, column A & B

The user is required to pick a name from the userform1 combobox and that directs them to Userform2 where a list appears of all names in the sheet.

What I would like is for the listbox to only display the rows relating to that name.

I would also like the combo box to only list the names once, instead of jane,jane,tom,dave,tom.... show jane,tom,dave.


Please see .xls attached, it will make so much more sense.