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.
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.
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]
21 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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
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
Hello. Below is example of similar work done by me recently: https://www.freelancer.com/projects/php/Build-excel-script/details Will be happy to create script for printing for you.
~~~ 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.
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.