Hmm doesn't seem to work for me? Do i need to have something in rowA?

max I will use is 300 barcodes per supplier (first 4 digits of barcode are supplier numbers)