Good day all once again,
I need a code that will generate a unique reference based on a users inputted name, eg. if the name entered in cell "A1" = "John" & the surname in cell "B1" = "Smith", then I need a returned value of "JS1", however if later a new user registers as Jerry Smythe the code will lookup for the same initials & the returned value would then be "JS2", any assistance as always will be greatly appreciated, thank you all & have a great day - Marco
Bookmarks