VBA Creating a list of unique values from one column based on criteria from another column

Hi,

Using VBA, is it possible to create a unique list of values from column A if column B meets a certain criteria?

For example,

COL A COL B
Dave Overdue
Dave Not Overdue
Glen Overdue
Glen Overdue
Ben Not Overdue
Ben Not Overdue
Adam Not Overdue
Adam Overdue

If the criteria is column B containing "Overdue", the returned list should be:

Dave
Glen
Adam

This removes "Ben" as neither row contains "Overdue" and then only returns unique values.

This unique list should be returned in a new sheet if possible.

Thanks