Excel Macro For Label Printing

We have an excel file that allows us to print a certain product label once the SKU is entered. It combines order barcode, product barcode with ingredients lists and lot numbers. (See Image 1 and 3) This works fine. Now we sometimes need to batch print around 100 labels with up to 30 differentiations. Doing that one by one can be time-consuming. We have a CSV file that contains an Order Barcode Number, a SKU and Quantity, (See image 2) All we need is a macro that prints out ONE barcode label and the quantities of the SKU required. In the example provided we need one barcode label


and these labels in the following quantities.

PL205 6

PL208 12

PL209 6

PL207 12

PL203 12

They NEED to come in this order. Order barcode and followed by the items for THIS order. Then next order barcode followed by the items. No combination of SKUs.

If required: The printer name is SATO CT412i

Attached is the modified excel sheet. We will use only the code, don't worry about the test products, you can add or remove products. All we need is the code to work no matter how many items.

Please note that the printer can't take 100 commands at once. So you might need to send to the queue which is more efficient that waiting for the printer to finish.

Skills: Excel, Software Architecture, Visual Basic, Windows Desktop

See more: label printing codeigniter, label printing excel 2008, label printing excel sheets, how to print labels from excel 2013, how to print labels from excel 2016, how to print labels from excel 2010, how do i print labels from an excel spreadsheet?, excel vba print labels, how to print labels from excel spreadsheet, how to print labels from excel 2007, how do i make mailing labels from an excel spreadsheet?, sticker label printing excel, label printing excel, excel macro website label input, label design for transfer printing, where i hire someone to write excel macro for me, VBA macro for excel, macro for excel, Do some Excel Work (One macro) for Inventory Management, how do i enlarge an excel spreadsheet for printing?

About the Employer:
( 1 review ) Tokyo, Japan

Project ID: #19734341

Awarded to:


I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

$100 USD in 2 days
(96 Reviews)

21 freelancers are bidding on average $140 for this job


Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl More

$220 USD in 4 days
(332 Reviews)

Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed More

$220 USD in 4 days
(110 Reviews)

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$150 USD in 3 days
(290 Reviews)

Greetings sir, I have read your project details and i will develop a software rather than excel macro that you can use to import both excel and csv data, and it will send multiple label print request one by one up t More

$200 USD in 1 day
(208 Reviews)

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. This is what i have done in Excel/VBA/MACRO. Just Creating forms, query, Macro, custom formula, etc... More

$155 USD in 3 days
(127 Reviews)

Sir, I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards Relevant Skills and Experience VB, windows desktop

$133 USD in 3 days
(54 Reviews)

hi , i am excel expert .i seen your project now and i am interested with your project so if you want me then please message me then i will give you quality [login to view URL] you

$80 USD in 1 day
(96 Reviews)

Hello, I am ready to discuss project with you. Being experienced in working on several excel projects related to macro/formula/vba/functions/charts etc. Based on that i can quickly help you in getting your project don More

$80 USD in 3 days
(36 Reviews)

I have more than 5 years of experience in advanced excel, VBA automation and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed couple o More

$70 USD in 1 day
(23 Reviews)

Hello. Below is example of similar work done by me recently: Will be happy to create script for printing for you.

$100 USD in 2 days
(21 Reviews)

Hi, I'm experienced in excel VBA event printing macro code, but honestly, I didn't really understand about what you need. So, if it's not bothering you, I want to discuss more detail about your project so I can give yo More

$35 USD in 3 days
(41 Reviews)

I have looked at your requirement in detail. I will provide a working macro which asks the user to select the CSV file. It will call a second macro which will open the CSV file and for each barcode specified it will pr More

$100 USD in 2 days
(4 Reviews)

Hi,Dear. I have experience at QL 570 and other printers... I will be your Freelancer Forever! I have many development experiences,getting work about . As I am interested in your project, I've read the project descripti More

$200 USD in 7 days
(5 Reviews)

~~~ Very interested to me! ~~~ Hi, dear! Feel contact me for these kinds of projects. I will provide you the best result on time. I am waiting for your message to have a detail discussion. Thanks.

$120 USD in 7 days
(7 Reviews)

Hi, Are you looking for an affordable rate on, we are a team of professional designers with 10+ years of experience in graphics and design, trust me our price is affordable with exceptional quality More

$40 USD in 3 days
(6 Reviews)

Hi! This sounds like a great opportunity! I'm Anoop and I work as a Label Designer and brand strategist. I have been working for 7+ years in a graphic designing firm as a designer and brand strategist and also recen More

$289 USD in 1 day
(0 Reviews)

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do th More

$140 USD in 7 days
(3 Reviews)

Hi, I am interested in your project and I would like to know more details. Kindly drop a message so we can discuss.

$30 USD in 7 days
(0 Reviews)

My skills include fast typing and data management. These would help me give a more efficient and effective output. I hope I can earn your trust and can consider me on this job.

$250 USD in 1 day
(0 Reviews)

Hello, I am ready to create excel macro for label printing. Can we discuss in details before starting? Highly experienced in Excel Programming, Excel automation and Macros. I am good at Visual Basic and .net for App More

$222 USD in 3 days
(0 Reviews)