VBA Same last names

[terisavzr]

I have a list of employees where some employees have the same last name. I have created a template that I can type in the employees last name and it will in another cell bring in the employee's first name. My complication is that I have a few employees with the same last name. I need a formula to stop on these and allow the user to choose the correct employee only in these cases of the same last name.

The attachment is a file I have created. The P-Card Template tab is where I want the information to be pulled to. The Coding tab is the tab I am having complications with. I have way more employees than shown on this tab. Though you get the idea. On the P-Card Template tab. If I type in Smith in the Last Name cell. It will bring up the first Smith from the Coding tab. But if I want the second Smith. I need to create an IF /Or or macro or something to allow me to choose the correct Smith.

Any Ideas?

[ranman256]

your search would have to display all matching answers.

case 0
Msgbox No Results
case 1
'load this find
case >1
'show list of results, let user pick from list

[WideBoyDixon]

For some reason, I'm being blocked from pasting the code I wrote. I've attached the workbook instead; sorry mods.

WBD

[terisavzr]

Thank you for this.