Normally I can limp along with limited VB knowledge but I am having issues.

I want to have a macro that will search (AD) by a string that contains a last name and put the first name into another cell. If there is more than one person with that last name it would create a list.

So if A1 had a last name and 5 people have that last name, B1:B5 would be populated as their first names.

Thanks for any help in advance.