Hello,

This is going to be hard to explain but i will try my best and may thanks for any help that you can give.

So i have 2 tabs.

on tab 1

Full Name First Name Last Name Name Display Place
Draco Reaper Draco Reaper Reaper, D United Kingdom

On Tab 2

Name Display Place
(This to be a drop down that This will look up the display name and then auto fill from there.
will show the full name and then
once you click on the full name it
will display in box as the name display.

test.xls

Thanks to all who come back to me with an answer to this.