If count > 1 then selection box? - VBA

[wrightyrx7]

Hi all,

Im trying to figure out the best way to do this and hoping someone could point me in the right direction.

Sheet1 - Employees data
Sheet2 - Log

Sheet2 - Log - Column A is for the employee number. When the user inputs the employee number it pulls through the employee details from the employee data using a worksheet change looking at column A.

However, we have a large number of people with multiple roles. So they appear on the Employees data multiple times. What i want is some way to get the user to select which role they are inputting data for (if this employee has more than one).

This could be a some sort of selection box, drop down list.... anything really. Its just important that in these cases a role can be selected.

Any help would be great, thank you.

 

[Akuini]

Could you post some data sample from both sheet? so we can understand it better.