in the attached sheet I have it set up that when operator chooses name in combo box it is enter in range V51:V68 and if gets then ther is a corresponding VLOOKUP Column W. I am looking for VBA that will put the name in starting and line V51 and moving down to next open line as new names are enterd. I also need it to look and if the name is already in the range then it doesn't enter it again.
gameon.xlsm
Bookmarks