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)