Good day helpful forum goers,

I'm working on a sheet where I want people to be able to select their name from a drop down list and have it automatically select their user number in a different box, or vice versa.

I also want it to have the capability to add new names / numbers to the list.

I'm not good with drop down boxes yet so any help would be greatly appreciated.

If this could be done in a VBA userform, that'd be perfect because I've got a couple of chunks of data that I want to make sure are also input at the same time using text boxes.

Thanks,


Paul