This simple small code will watch for user input, and once user enter new name in column C, code will generate new ID (4 to 6 characters) and make sure it is not repeated, then put it in column B, fun small code I created for free online to answer a request, thought that sharing it here might benefit others, enjoy!