I need to generate two barcodes per label using an Excel sheet. The end results should look like the image attached
I need to make sure to serialize them so I can spare myself hours of typing. I have chosen Excel to make this easier. My Data tables look like the following (only did 20 lines of 75)
Sheet1 Sheet2 83A J 01C1 83A J 01C2 83A J 01D1 83A J 01D2 83A J 01E1 83A J 01E2 83A J 02C1 83A J 02C2 83A J 02D1 83A J 02D2 83A J 02E1 83A J 02E2 83A J 03C1 83A J 03C2 83A J 03D1 83A J 03D2 83A J 03E1 83A J 03E2 83A J 04C1 83A J 04C2 83A J 04D1 83A J 04D2 83A J 04E1 83A J 04E2 83A J 05C1 83A J 05C2 83A J 05D1 83A J 05D2 83A J 05E1 83A J 05E2 83A J 06C1 83A J 06C2 83A J 06D1 83A J 06D2 83A J 06E1 83A J 06E2 83A J 07C1 83A J 07C2 83A J 07D1 83A J 07D2
I need the tables to be read for the top barcode from Sheet1, and the bottom from Sheet2.
I can not figure out how to make both of these work. I need to add another thirty sheets to finish all the labels. Any suggestions on how the Joins should be setup to make it work? Everything I try seems to tell me that its not valid "Row 1 does not have a table referenced by another row" I am not sure what this means.
Please sign in to leave a comment.