Drop-down list - EXCEL Automatic field update after changing the list source

Hello,

I need help with the dropdown in EXCEL namely ...

How to do to update the position in the cell e.g. A2 after selecting from the drop-down list e.g. text: Cover 12.
When I change the field "Cover 12" in the source of the drop-down list to eg Cover 14

The problem is that I have to manually select and change A2 positions.
I have a large warehouse that I added to the drop-down list and if I change anything, e.g. add a space or as in the example above, this item does not change automatically in the field where it was selected, the problem is that I have 2000 items that are already functioning and were selected from drop-down list and I would have to click a few hours in which I added a number or changed the name

I wrote it a little chaotically ..
Please help

long ago you should have had a real database program

Thanks for the comment, I just like Excel
I made a really good combine harvester and everything has been going on for a year, including the Warehouse, PZ, FV, PF, but this problem has been bothering me for some time. Besides, I am happy with what I have and for free.

If you can help ..? then write about my question.

bigjeans wrote:

I have to manually select and change A2 items.

Sample sheet attached

I am sending a sample file.

In the example, I have to click through position B4

Please help

Macro only, customize. See 'warehouse' events

Thank you for your answer
I still have a question.

I can see that VBA refers to sheet 1 as it is sequentially.
And if I have several worksheets where there is a selection from the list and I would like the name to change in different columns in all of them?

Is it doable?
How to add more sheets to VBA? I'm not very good at this programming, but probably no other method?

instead of sheets (1), enter sheets ("Sales")
u me not polish excel, VBA doesn't want signs etc.

Added after 5 [minutes]:

bigjeans wrote:

i have several sheets

bigjeans wrote:

in different columns

add example, I don't have time to emulate

I'm sending my combine ;)

Please check if it can be done, practically in each of the sheets there is a selection of items from the list. and all items must be updated if I change something in the Warehouse.

Everything can be done

THANK YOU FOR YOUR HELP! :)

That's what I meant !!! COOL

greetings :)

Added after 18 [hours] 47 [minutes]:

Hello, I have a question because I have an error.
Could this be because I have some sheets blocked? and then the function does not work?

Below scr.