Make a dropdown based on all the unique values in a column

[SandsB]

I get a daily file with about 1,000 records and each one is assigned to one of 15 (give or take) employees. The ID number of those people is in column B. Every day I run a macro on that file to generate a report of each record's status. I want to add something to my macro so that each of the employees can run a report for just the records they are responsible for.

I think the best way to do that is have the macro start off by prompting them for their employee ID - it's a string of 3 letters and 2 numbers. EX: ABC123. (Actually, I think a drop down based on the IDs in the day's file would be better because it would eliminate the possibility for typos but doing that seems infinitely more complicated).

If I get the user's ID by having them type it in, how do I get my macro to delete all of the records that don't have that user's ID in column B?

 

[SandsB]

I found a fix on MrExcel: Deleting rows if they don't contain certain text values?

But it would be nice to learn how to do it with a dropdown.