Hello,
Thank you for your invitation!
My name is Chris and, as you can see from my profile, I have 16 years experience with Excel/VBA and 13 years teaching them both. I read carefully your post and reviewed the attached file. It's clear how to fill-in the labels sheet. I have only 2 questions. The first one has to do with the way this automation will start. There are 2 possible ways:
1. The user adds all data into "Packing List" and then presses a button (shown this tab) to fill-in the corresponding labels.
2. Labels are created as the user is entering data into the "Packing List".
The first method requires user's intervention, while second method not. However, second method maybe slower than the first one, especially in case the user makes changes or fixes to the entered data, because the code has to check for any change on this range and adjust te labels accordingly.
Second question: Do you want also a button (and code) for printing the labels?
Looking forward to hear from you,
Kind regards,
Chris (chriskerpini)