Hi there,
Here's a cheap 'n' cheerful approach which might get you moving in the right direction.
Take a look at the attached workbook and see if it does what you need. It uses the following code:
The above code assumes that each label is printed on a single sheet. If you're using (e.g. 3 x 6) label sheets, the above code and the layout of the "Labels" worksheet will need to be altered accordingly. Let me know if you need any assistance with that.
Hope this helps - please let me know how you get on.
Regards,
Greg M
Bookmarks