OK so I have a sheet on which I report nonconformances to suppliers of a certain raw material. We have six suppliers and the number of SKUs for each supplier varies from one to a few dozen.

The report lists each SKU being rejected as a line item. Currently, I just use data validation (from the table on the Metrics tab) to select the SKU which is unwieldy for a few reasons. Firstly, because one might have to scroll through dozens of SKUs to select the one needed. Secondly, it lists all SKUs even those that are not for the specific supplier.

Each SKU code begins with the first letter of the supplier's name. Can anyone help a guy who is too hung over to think this through right now? ;-)

Attached Files

Dummy.xlsx (21.4 KB, 19 views)

I am not quite sure what you mean.

Is it that if you choose for example Buzzwater in Summary!A3 then you want in A6 to be able to choose between:
BECH25-135x61
BECH25-235x61
BEWH25-130x55
BSBW14-080x56
BSCH14-080x56

and only between these etc.?

Yessir! But also, if the list of SKUs is too long, like for the vendor beginning with H, an alternative to data validation that will allow longer lists perhaps.

But yes, the first letter thingee is the priority.

Is it like shown in Summary!A6?

Attached Files

Dummy_3.xlsx (22.7 KB, 10 views)

Nice. That'll work fine! Thankee, lad.

Another nice feature of your solution is I don't need the first letter of the SKU to agree with the vendor name. In fact, one vendor was just acquired by another company, now their codes and name do NOT agree, and we have no intention of changing the SKUs. This solution circumvents that mess as well as the possibility that we might have two vendors with the same first letter in the future.