I've seen a few things out there, but I haven't found anything that addresses multiple qualifiers, so here we go:
On Sheet 2, column A contains the part number, Column B contains the EIN number. Sheet 1 is where you would use a barcode scanner to scan a label. The format of the scanned barcode is this: (01)123456789(10)12345(17)123456. Qualifier (01) is always the same, The other two sometimes are in different positions. The length of the numbers between the qualifiers is not consistantly the same unfortunately. I need a way for VBA to see that scan, extract the number between the first two qualifiers and place it in a cell, then do the same for the numbers between the next two qualifiers, utilizing a total of 3 cells. From there I have to cross-reference a sheet to extract some other data (which I can do).
Any help would be greatly appreciated.
On Sheet 2, column A contains the part number, Column B contains the EIN number. Sheet 1 is where you would use a barcode scanner to scan a label. The format of the scanned barcode is this: (01)123456789(10)12345(17)123456. Qualifier (01) is always the same, The other two sometimes are in different positions. The length of the numbers between the qualifiers is not consistantly the same unfortunately. I need a way for VBA to see that scan, extract the number between the first two qualifiers and place it in a cell, then do the same for the numbers between the next two qualifiers, utilizing a total of 3 cells. From there I have to cross-reference a sheet to extract some other data (which I can do).
Any help would be greatly appreciated.