VBA searching for numbers and copying the ones next to it

[ASadStudent]

Hello Everyone, I am trying to automate the copy and paste proces. The things that need to be copied is the amount of times a product is sold. And the way I can find these products is by the code that they are assigned. All products that aren't sold won't show up in the file so I also need to figure out a way to skip numbers that aren't in the file.
These products have a specific code with which I am trying to find them and then copy the number of times sold which is 4 spaces to the right.

For example the code is in the A columm and consists of 4 digits (3000, 3001, 3002 etc). Then the number of times it is sold is in E4.
Can anyone help me find out how to do this ?
Thank you very much for helping me figure this out

 

[ouvay]

Appreciate the feedback.. have a good one