Customer ID advice please

[ipbr21054]

I send values from userform to worksheet.

I’m trying to stop mixing up customers of the same name.
When I send files to worksheet the code adds 3 digits to the customers name
Tom Jones 001
Next purchase from Tom Jones will then be saved like Tom Jones 002 etc.
Only thing with the above is are both Tom Jones the same people ??

So as my sheet is mainly saved eBay purchases I also assign to the sheet the customers eBay username.

What kind of code are we talking so it can look at customers name I’m about to save along with there eBay username.
Depending on the answer depends if the same ID is used or another is created for this customer.

I must advise as at present I have not used any ID at all so all my customers saved are like.

Tom Jones 001 002 003 004 005
Where Tom Jones 003 might be a different person to 001 002 004 & 005
So I’m currently checking there name alongside eBay username.

If you need any code etc from how I send from userform to worksheet etc just ask.

Maybe somehow check the customer with username whilst the userform is open before I save to worksheet.

Now sure how the saved name will look in the worksheet.
Like mentioned currently Tom Jones 001 so maybe just add the ID after what’s there so far.

Thanks.

 

[brent3162]

Instead of ebay username, have you thought about using the users phone number? I prefer to use that instead of any other form of ID.

 

[ipbr21054]

EBay don’t disclose that info.

Some that do get show also put 00000 000000 etc

 

[brent3162]

apologies, I thought people I buy from see my number but guess I was wrong.