revilo
New member
- Joined
- Sep 30, 2011
- Messages
- 22
- Reaction score
- 0
- Points
- 0
Hello All - been a while since I was on here!
Basically, what I am wanting to do is use excel to generate shipping labels for our industrial label printer (yes, the software included is AWFUL!).
Basically, what I am doing is using Concatenate to the basics like =CONCATENATE("Deliver to: ", B1) for the name of the receiving company.
Where I am getting stuck is with labels for shipments with multiple packages. Eg, I want to be able to have a cell where I enter the number of parcels in the shipment, and excel will generate the labels with 1 of 3, 2 of 3, 3 of 3 etc, and print them.
Not sure if this is achievable with a formula or not (I know the printing part isn't really - I will have to use a VBA script for that), and I would appreciate some opinions of the local guru's!
Thanks in advance.
Basically, what I am wanting to do is use excel to generate shipping labels for our industrial label printer (yes, the software included is AWFUL!).
Basically, what I am doing is using Concatenate to the basics like =CONCATENATE("Deliver to: ", B1) for the name of the receiving company.
Where I am getting stuck is with labels for shipments with multiple packages. Eg, I want to be able to have a cell where I enter the number of parcels in the shipment, and excel will generate the labels with 1 of 3, 2 of 3, 3 of 3 etc, and print them.
Not sure if this is achievable with a formula or not (I know the printing part isn't really - I will have to use a VBA script for that), and I would appreciate some opinions of the local guru's!
Thanks in advance.