Make a choice in an "extensible" list

Hello,

I have to introduce often the same entry (i.e. a firm or commerce name).
To avoid having to make all te time the same entries and to avoid entring the same firm with different spellings I imagine making a choice from a list, list that would be able to "learn" new entries.

Example: When I type the "D" of "Dupont de Nemours", Excel would propose all entries beginning with a "D", and if I introduce a name that doesn't still exist in the list, I should be made attentive to that fact and proposed to add that name to the list.

Is that possible? How?

Thanks for all hints.

Regards

Aloha

Hello Carim

thank you very much for your quick response.

Best regards

Aloha

Hello Carim, once again,

A restriction in the use of validation makes a problem to me:the fact that the list has to be in the same sheet!

My situation: I have a WB with a dozen of sheets with the same structure where a dozen persons make entries of the same kind (bookkeeping).

If on can not bypass this restriction, that means that I have to have a list per person, instead of one list for all.

What do you think about that?

Regards

Aloha