Unique values in listbox in sheet2 from sheet1

[santbiju1]

Hi

i have two sheets named employee master sheet and pc details sheet.
in pc details sheet i need the listbox which should display all the employee names from employee master which is active and should be unique.
if i select the employee name from that listbox r, then the remaining columns should automatically fill like designation,department etc...

sample file attached

[skywriter]

Your code is password protected.

[Naveed Raza]

Hi

your VBA Script is Password protected, so I have created new sheet as Output and based on the function I have created

please have a look to that sheet and details are mention there and have validate and confirm

[santbiju1]

now i have attached the sheet without password.
I need employees from employee master to be displayed as list in pc details without blank in userlist column.