Auto Generate Labels

[BradFoxii]

Hi,

I'm trying to work out if its possible to generate a number of labels from 1-68 labels.
each label has unique data based off of a data sheet.
ill attach an image that displays the label and where certain information needs to populate.

The Number at the top comes from the data sheet Column (B) and there is usually multiple unique numbers, Description comes from a secondary sheet with a list using the top number as the reference (currently using index/match)
Batch comes from the data sheet index/match, index being Data Sheet Column (H), PO is from Column A of the data sheet and the defining criteria for the label. i would like it to use PO (Data Sheet Column (A)) to determine how many labels are need to be generated and use it as the criteria to determine what the top number will be as there are multiple unique values per PO.
QTY comes from Data Sheet Column (D).


i'm trying to make it so all the user needs to do is input the PO number and excel will print a label for each row of data that has the same PO reference.

I'm currently just using a Userform i made to create these labels which works okay but i would like to be able to automate it and just have a PO as the only criteria need to print them all off at once.

I'm sort of going on out a whim here whether it's a possibility or not.

All help would be greatly appreciated.
Thank you.

 

[BadgerRoad]

Are these actually peel off labels such as an Avery label? If so, what is the name and number of the label?

 

[BradFoxii]

Are these actually peel off labels such as an Avery label? If so, what is the name and number of the label?

Hi Badger, They're just A4 pieces of paper at the moment.

 

[BadgerRoad]

I would suggest creating a new sheet within your workbook that contains all the information you want on each label. Then use the mail merge feature of Word to format and produce the labels much like you would do if you were producing address labels.
Following is a YouTube video that describes what I am suggesting.

 

[BradFoxii]

This worked great for me, thank you!

May i ask another question regarding sorting a combo box based off of a list box change in the same thread?

 

[BadgerRoad]

You are welcome. Glad it worked. Thanks for letting me know.
I suggest you post it in a new thread. You'll probably get a better response.