I'm still not quite understanding, I could upload the files I'm currently using for reference if that would help.
If create a table with customer information and rows for orders I can imput that onto the labels to insert customer info, sale1, sale2, sale2, sale4, sale5, next customer info, etc.
When I do it in this fashion if the customer bought two things it leaves me with 3 blank labels when I'm ready to print. This would lead to many wasted labels.
I'm not sure if this is the same way you're explaining to do it?
I really appreciate your time, do you have any recommended places I can look to become more familiar with vba and these types of situations? I feel bad basically asking you to teach me so I can understand the advice that you are giving. I don't mind learning more and getting a better understanding and then coming back to this thread to move further but I'm having a hard time finding a good place to learn the information.