I have a parts list that includes multiple fields of information and I am hoping to auto generate a list I can use to make parts labels. The workbook has multiple sheets, and among the information, parts may have multiples for the QTY field. How can I pull out the QTY and Part Number field, generate the appropriate amount of entries and move to the next part and do the same on all parts and sheets, etc. in order to have a complete list of entries to make an appropriate amount of labels in Word.
For example:
Label: Part 1 QTY: 30
Label: Part 2 QTY: 5
I would need to generate 30 individual labels for part one and 5 for part 2.
Thanks.
David.
For example:
Label: Part 1 QTY: 30
Label: Part 2 QTY: 5
I would need to generate 30 individual labels for part one and 5 for part 2.
Thanks.
David.