first off i cant take credit for the majoraty of this i have just modfied the sheet called Input and have added the sheet called Check String
if you recongise it then please messgae/post here as its bloody great
But i have one slight issue and I'm not sure how to fix it, some of the locations have a check string which is just 2 characters long ( 2 digits ) and the barcode this produces is unable to be scanned, attached is the example i have tried my idea on location AA0011 to add 5 leading zeros, but I'm not sure if this is correct method or any one has another idea
cheers all for your time
p.s sorry its zipped but was just over size limit
Bookmarks