#1
|
|||
|
|||
Alternative to a data validation list?
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? ;-) |
#2
|
|||
|
|||
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.? |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
Is it like shown in Summary!A6?
|
#5
|
|||
|
|||
Nice. That'll work fine! Thankee, lad.
|
#6
|
|||
|
|||
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.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data Validation - List | Webbn111 | Excel | 9 | 03-09-2016 04:30 PM |
Trying to get Data into Validation List according to Client Name and Document Type | Maoz | Excel | 5 | 01-24-2016 01:17 AM |
Data Validation List based on Two Named Ranges | Rich18144 | Excel | 4 | 01-14-2016 04:37 AM |
Data validation list filter with range defined by OFFSET | Mango123 | Excel | 4 | 03-18-2014 02:52 PM |
Conditional data validation (list drop-down) | click4akshay | Excel | 2 | 04-28-2011 01:51 PM |