so lets take the test sheet I uploaded. You want to plug in codes in the little table to the right for a,b etc. and then the code will check each code if it is the same as in one of the codes you specified there.


VBA has to somehow know that code N4965017 is all warehouses or small or regional. There must be a reference where vba will look where to put the x