Automatically fill and print DYMO label

Hi All,

I'm trying to work out something that would automatically fill a DYMO label template and print the label. However, I noticed that this is way over my head... So if there is anybody out there who can help... please!

Attached file has a few sheets.
Sheet "WARR_FILL_IN" only contains fixed info which is transferred onto the label.
Sheet "Part" is the sheet where partnumbers and serialnumbers etc are scanned.
Sheet "DYMO label" contains the DYMO label layout (A1:E4) and some calculation explanations (G1:L3).

What needs to happen:
1. People are scanning partnumbers and serialnumbers in the "Part" sheet.
2. When there are 60 scans (column C), the box is full and a DYMO label should be printed for this box.
3. Scanning continues and when another 60 scans are done, the 2nd label should be printed (can be different partnumber).
4. A re-print option for a label should be possible via a re-print button

On the "DYMO label" sheet, I've explained where the data is coming from and also how the 2nd label should look like, based on the scanned examples in the "Part" sheet.
The DYMO printer is a DYMO LabelWriter 400 Turbo.

I'm not even sure if the above is possible in the first place. I would really appreciate it if somebody is able to shine some light on this, as I'm completely stuck...

In case of any questions, please do let me know.

DYMO file.xlsm
Thanks as always!
Peter

Hi all,

Can you tell me if it is possible to automatically trigger a DYMO label print when certain criteria are met? As in my situation, when 60 scans are completed?

Thanks,
Peter

Yes this is all possible. However, you may be better off going to the Commercial Services Section and having an Excel Forum Expert help you build this.

Oke thanks!
Maybe a silly question, but how does that work? I can see paid subscriptions of certain amounts, each representing a number of points.
How many points do I need for a certain request?
I tried to find some clarification on this Commercial section, but can't find any...

Thanks again!
Peter