Evaluate Match 3 sheets continue when error (probably Loop?)

Hello,

In the attached Example I'm trying to get excel to fill in Sheet_B and Sheet_C with data filled in by a user in Sheet_A.

The problem is that the code stops as soon as it cannot find a stock number in Sheet_B that is listed in Sheet_C. Also, it must be possible to make mistakes that are shown after the macro filled in the stock numbers that were found in Sheet B and C. In short:

1. Pressing the button in sheet A fills in Sheet B and C.
2. When it cannot find a (new) stock number it should bring up a msg box with the stock numbers that could not be found.

This is the code I have so far:

Please Login or Register  to view this content.

Thanks in advance,

Psj

Try with this

Please Login or Register  to view this content.

Kind regards
Leo