Leg_Drawing_No - Unique for each Base_ID & Sub_ID Part_No - Unique for each Base_ID & Sub_ID "Will the table names always be the same, or will they change with the next data import?" - The names of the tables and layout will always remain the same. "What should go in the 'Leg no' box?" - Leg No. I created pictures to explain better what needs to happen. "Which format should we use? The label sheet in the attached file is not the same as the screen captures." So there needs to be a loop macro for the labels to be generated and printed. I this example, there are a total of 14 RSCs so I will need to print 14 labels. I need a label for every OP (Operation) listed in the table that's on the right. "I assume next op will always be same sub ID." - This is where things get complicated and beyond my macro capabilities. These three are always blank.Įach Sub id that is not 0 will have a part no that is located in column "G" Sub ID 0 will always have a part number located in column "E". There should not be any blank fields on the label except for Quantity, EMP No., and Date. In the example, Sub ID numbers that are 0 belong to part # 29502066-14Īll Sub ID numbers that are 1 belong to part # 29502066-14AĪll Sub ID numbers that are 2 belong to part # 29502066-4B Your help on this is greatly appreciated. In a different post, I asked for assistance printing to Zebra printer, but I think that the post died. This needs to be done 14 times and printed on the zebra label printer that on the local network. The Label Tab needs to be filled out with the information from the Tables Tab. So once you click on the button and enter the Work Order, in this case W157772, and then hit print the following needs to happen: This is because there are a total of 3 SubNo (0,1,2) and each SubNo has a RSC (SubNo 0 has 6, SubNo 1 has 4, SubNo 2 has 4)Īll of this will change once a different Base ID is entered. On the attached spreadsheet, the total amount of labels that need to be printed is 14. The label tab is the one that needs to be printed. MoveTags has the button that needs to ask for input. Tables Tab generates data automatically by using SQL and the data from A1 on the MoveTags Tab. The spreadsheet has 3 tabs: Tables, MoveTags, Label. I need VBA code for the attached spreadsheet.
0 kommentar(er)
