No sorry, it's not that.
The problem i've now it's that if i don't have nothing in Columm B, the macro stops and gives me an error.
So, since i've persons with numbers and others without numbers, i can't use the macro
I was just thinking, if i only use the columm A, i can put there names with numbers or without numbers ex:

Columm A
Joao n.º123456
Luis
Paulo 123431
Helder

In my opinion, it's more easy insert only a dropdown, select the name and keep writing. If i use the dropdown, select then i need to press mouse outside the dropdown to appear the number. That will reduce the speed of writing.
With 1 columm and 1 dropdown, after pressing enter a just need to write without pressing the mouse.


Hope you understand me now

Thanks