Suoritettu

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

2300027750383

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.

Taidot: Excel, tietojärjestelmäarkkitehtuuri, Visual Basic, Windows Desktop

Näytä lisää: 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?

Tietoa työnantajasta:
( 1 arvostelu ) Tokyo, Japan

Projektin tunnus: #19734341

Myönnetty käyttäjälle:

aubrey03

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 2 päivässä
(96 Arvostelua)
5.6

21 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

schoudhary1553

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 Lisää

$220 USD 4 päivässä
(332 arvostelua)
7.9
zekovicm

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 Lisää

$220 USD 4 päivässä
(110 arvostelua)
7.2
P0L

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 3 päivässä
(290 arvostelua)
7.2
ineedWorkJob

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 Lisää

$200 USD 1 päivässä
(208 arvostelua)
7.0
polarjin2017

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... Lisää

$155 USD 3 päivässä
(127 arvostelua)
6.9
sonarkaushik

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 3 päivässä
(54 arvostelua)
5.7
mtdevil369

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 1 päivässä
(96 arvostelua)
5.6
dalsaniyasonu123

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 Lisää

$80 USD 3 päivässä
(36 arvostelua)
4.8
bhupendrayadav

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 Lisää

$70 USD 1 päivässä
(23 arvostelua)
4.4
KozlouAlex

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.

$100 USD 2 päivässä
(21 arvostelua)
4.3
nurnga1218

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 Lisää

$35 USD 3 päivässä
(41 arvostelua)
4.5
NeilSargent

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 Lisää

$100 USD 2 päivässä
(4 arvostelua)
4.1
RiHCh

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 Lisää

$200 USD 7 päivässä
(5 arvostelua)
3.6
AlexanderPGR

~~~ 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 7 päivässä
(7 arvostelua)
3.5
JUSTDIGITALPVT

Hi, Are you looking for an affordable rate on freelancer.com, 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 Lisää

$40 USD 3 päivässä
(6 arvostelua)
3.2
kreaytivefox

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 Lisää

$289 USD 1 päivässä
(0 arvostelua)
0.0
techlinesols6

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 Lisää

$140 USD 7 päivässä
(3 arvostelua)
0.0
sihabmahmud2019

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 7 päivässä
(0 arvostelua)
0.0
ayantikacomroy

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 1 päivässä
(0 arvostelua)
0.0
Webxpert4u

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 Lisää

$222 USD 3 päivässä
(0 arvostelua)
0.0