Hi, I've been creating a spreadsheet which contains a user form for employee details, which when you save it enters it in to a table on the same worksheet. I now want to be able to have a drop down box on a separate worksheet, where the first and last name are displayed. Then when the user clicks the name the rest of their details are displayed below. Any ideas? I thought maybe I could use a VLOOKUP, but I can't get it to work Thanks x