The part number is dependent on Sub ID.
In the example, Sub ID numbers that are 0 belong to part # 29502066-14
All Sub ID numbers that are 1 belong to part # 29502066-14A
All Sub ID numbers that are 2 belong to part # 29502066-4B
So yes.
There should not be any blank fields on the label except for Quantity, EMP No., and Date. These three are always blank.
Each 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".
"I assume next op will always be same sub ID." - This is where things get complicated and beyond my macro capabilities.
I need a label for every OP (Operation) listed in the table that's on the right. OP (Operation) = RSC column.
I this example, there are a total of 14 RSCs so I will need to print 14 labels. So there needs to be a loop macro for the labels to be generated and printed.
"Which format should we use? The label sheet in the attached file is not the same as the screen captures."
Use the new attached spreadsheet. I created pictures to explain better what needs to happen.
"What should go in the 'Leg no' box?" - Leg No. = Sub_ID = SubNo
"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. The quantity of data will change.
Table Legend:
Row_ID - Do not use
Create_Date - Do not use
Base_ID = base = W.O.
Sub_ID = subNo = Leg No.
Part_No - Unique for each Base_ID & Sub_ID
Part_Description - Do not use
Leg_Drawing_No - Unique for each Base_ID & Sub_ID
seq - Do not use
rsc (resource) = OP (Operation)
Date - Leave blank
Quantity - Leave blank
Emp No. - Lave Blank
I have attached a new spreadsheet with a new VBA code.
As always, thank you for the help!
Bookmarks