So I will have a master list of 500+ items. In my example, my master list has Widget, Trinket, Object, etc. I'd like to create a sub list in columns A and B to take items from columns D and E but ONLY if there's a quantity in column F. I would like the number of items in the sublist for each item to reflect the quantity that I have in column F.
So in my image example, I have the number 12 in the # of Items columns because I want 12 instaces of Widgets to appear in the sub list with the correct barcode associated with Widget. Then, I want 6 instances Trinkets to appear with its respective barcode and 12 instances of Objects with its barcode. There's no quantity in column F for Thing, so Thing shouldn't appear in the sub list at all.
If were to change the quantity from 12 to 9 in my master list for Widget, then Widget should only appear 9 times in the sub list, not 12.
I hope this all makes sense! Thanks in advance for any help!
So in my image example, I have the number 12 in the # of Items columns because I want 12 instaces of Widgets to appear in the sub list with the correct barcode associated with Widget. Then, I want 6 instances Trinkets to appear with its respective barcode and 12 instances of Objects with its barcode. There's no quantity in column F for Thing, so Thing shouldn't appear in the sub list at all.
If were to change the quantity from 12 to 9 in my master list for Widget, then Widget should only appear 9 times in the sub list, not 12.
I hope this all makes sense! Thanks in advance for any help!