How to create barcodes in Excel that WORK!

[@LeilaGharani]

Grab the Excel barcode generator from here 👉 pages.xelplus.com/barcode-generator-file

[@karhukivi]

I never cease to be amazed at what Excel can do and how well you explain these features - thank you, Leila!

[@kennethlee3177]

You're the best teacher when it comes to Excel, Leila. Thanks for sharing all these wonderful Excel tips! :)

[@justanotherexmo48]

I accomplished this by creating my own barcode font that I drew myself in a font creator. I drew a set of characters for the category, manufacturer, product and check digit. I used VBA to do the calculations and for the font output I used offset ascii characters in the map so that each region had its own 10 digit section. I also drew generic bars for inside and outside braces. Fortunately the VBA structure works well as I drew these about 15 years ago and it has performed in all versions of Excel. I am a price book manager for a company with 80 stores and this is used for generating order guides, shelf tags and waste logs.

[@PhenomenalChezline]

Leila, when I came here, I wasn't expecting this level of detail but you really wowed me. I couldn't stop watching and learning. Awesome channel. Keep creating great content!

[@johnboyd6943]

Hi Leila, over 10 years ago I made a barcode generator in Excel 2010 without using VBA. I used it for years in the company I worked for - it worked perfectly. Love your videos, there is always something to learn even though I'm in my 70s.

[@Talaran12]

Hello Friend! I know this is an old comment, but if you still have the formula you used for this I would love take a look and learn from it! It would go a long way on a project I am working on.

[@johnboyd6943]

@@Talaran12 Sure, happy to help. I just don't know how I'm able to get the file to you without the whole world knowing either of our contact details. If you have any ideas, let me know.

[@username42]

so pete shared the workbook to her freely, then she shared with us freely and then she uploaded to youtube and youtube shared us freely and she got all the monetization money from youtube so everyone wins :D such a nice win win situation in data age :) you guys z generrations are so damn lucky to be born recently.

[@harshverdhansaxena6025]

We never asked our parents to bring us in this world... However, I'm thankful to everything as it feels amazing to see soo many solutions to just a particular question!

[@franknicaragua]

Simplest barcode ever: Download Code39 true type font. Install it. Now you have a new font in your programs. Go for example to Excel. Write something in a cell. Create a formula that concatenate an asterisk&what you write&an asterisk (eg.. *hello*) Change the default font in this cell to Code39. Voila! (note: the asterisks tell the scanner where the real text starts and ends). This font is available in any program (excel, powerpoint, word, etc)

[@matchstickdesignco]

Been doing it that way for 15 years.

[@petemenhennet9792]

But the point was to learn how to use VBA ......

[@newkiddgames6322]

I use barcodes in Excel all the time. The difference is mine is a "barcode" font that I down loaded and you have to put an "*" before and after the word/number. So my formula is very very simple. ="*"&A1&"*" A1 can be any cell.

[@appliancetraining]

Genius. Just what I needed. Thanks

[@appliancetraining]

Something is weird, I got it to work great, but.. if I click in the cell with your formula, sometimes the formula becomes the barcode , rather than what’s in A1. Any thoughts? Thanks. For your help

[@ladellp5135]

The entire time I'm listening to your voice, I could not stop thinking about how beautiful it would be waking up to a "good morning, how did you sleep last night?" from you on a daily basis. OMG... You're AWESOME.

[@aspalding4044]

Leila, you are such a charmer. I have always wondered about how barcodes worked and how to create them. Your simple, clear and detailed explanation did not miss it's mark! You must be an amazing person, thank you so much))

[@victortomno8321]

Dear Leila, you have done a wonderful job in showing us that it is possible to generate a barcode by use of Excel. I have also tried to prepare one like that, I only stopped at the point where you needed to link with VBA array.

[@mcd22630]

Think I speak for many when I say, what we really want is a video of you cooking using the Chipotle Honey Barbecue Sauce recipe. A hearth felt thank you to Pete and yourself on your explanation of bar codes.

[@LeilaGharani]

Fortunately for everyone the bottle is already empty :)

[@junaidali1252]

U r the best Teacher Leila, ur style of teaching is marvelous ur accent of talking is very nice as u r nice too. Thanks my Teacher.

[@arounaalaho6357]

Leila you are among the bests ever. Thank you for sharing important stuff here!

[@LeilaGharani]

Thank you for the kind words.

[@JeremyMcMahan]

As an exercise I just did this in formulas without VBA using a left and right lookup table and VLOOKUP. Works like a champ! Thanks again Leila for the fun video!

[@LeilaGharani]

Glad we inspired you to try it your way. This is how real learning happens. Thanks for sharing!

[@AngeloHafner]

Your videos are fabulous. You transmit knowledge of high complexity in a simple way. Thank you!

[@LeilaGharani]

Glad you like the videos Angelo!

[@VatsalModi1]

Super video! Thanks a lot. I wanted to create some barcodes for my items with confidential product data For example: I want the barcode to tell me the exact product specifications and pricing details when I scan it However, I dont want anyone else to be able to get the same information This is particularly for exhibitions where we have multiple clients and sometimes it is overwhelming when multiple people come in and need pricing or specs instantly

[@mmci1525]

Cool system for American 12 digit codes, great way to see people learning how the check digit is calculated, and not just a random number.

[@yokerpl]

I actually used once bar codes generation in Excel at work - real life situation, valid business case, nothing like doing it just for kicks: the company I worked for used to run their operations on a little bit obsolete software that didn't allow printing multiple labels at once. As long as user needed 1 or 2, it was ok - she/ he could do that manually. No issues with that. However, every once in a while they came across a situation in which 100 or 200 labels had to be printed. Manually that would have been really time-consuming and error-prone (some could have been skipped) process. One simple loop did the trick: generate bar code for whats in A1, print, go to A2, generate bar code, print, repeat. It worked an was for "free" (users had on their laptops Excel installed anyway). I would not underestimate this functionality. I've been watching your clips, your skills in explaining complex ideas is astonishing. Keep doing great job, thank you!

[@casewhite5048]

how did you write the loop script in excel

[@yokerpl]

@@casewhite5048 VBA (alt + F11 to open it), you can use few different types of loops: do ... while, do... until and my favourite "for i = 1 to Range("A1").End(xlDown).Row". Google tutorials on VBA loops, you'll find thousands of them

[@casewhite5048]

@@yokerpl thank you

[@TalhaKhan22]

The way you explained is very simple and easy. Thank you

[@akshaygarg4151]

Nice to see that this is possible in excel, as we all know there are multiple ways tof doing same thing excel, this can be done by using V lookup function also as in that way we dont need to run any of the macro

[@KallunWillock]

Thank you, Pete! This is excellent! Thank you Leila for the helpful explanation!

[@LeilaGharani]

Pete is great! Glad you like it.

[@petemenhennet9792]

Very welcome.

[@darrylcampbell4426]

I follow your videos because I love Excel, but this is the first time you've taught me something I didn't already know. Amazing!

[@LeilaGharani]

Finally! I was almost running out of ideas :)

[@darrylcampbell4426]

@@LeilaGharani Haha! Apologies if I sounded patronising, I didn't mean to. I just really love Excel and so spend quite some time playing with it! Perhaps some videos on game programming for those downtime moments? Or maybe that defeats the theme of productivity this channel emanates! :D

[@LeilaGharani]

Haha, no worries! It's great to have you here. What is a downtime moment :)

[@darrylcampbell4426]

@@LeilaGharani Guffaw. You run a tight ship I see

[@BillHester2011]

Ha ha ha "High fructose corn syrup, that's the first ingredient. Doesn't sound so healthy but I already finished it." Leila I am so glad I subscribed to your channel... So intuitive, so easy to listen to and absorb; those hilarious comments are just icing on the cake.

[@dennisd5776]

Thank you for sharing Pete's code and making it understandable. I learn so such from your videos.

[@LeilaGharani]

Glad it's useful for you Dennis.

[@pegwinn]

I like it. But, I work in a warehouse and make barcodes all day in excel using a barcode font and placing an asterisk in front and rear of the data to scan. No VBA needed. We use code 128 barcodes btw. Always nice to learn a bit more VBA though.

[@dharmeshrana7548]

Excellent work, you and Pete!

[@aperxmim]

I actually used Barcodes in Excel when I scanned files, I used a barcode reader that was linked to my computer, so instead typing the barcode from the folder in the Excel spreadsheet I just scanned it, easy peasy.

[@Bens598]

It came on my recommendation, I went all ears!!

[@gUdZL0vE]

Hi Ms. Leila, i am really in a dilema thinking how can i use excel to create barcodes for our internal use to monitor inventory.... Then your video was recommended, i felt like, God thanks for this video...!!!! And im all ears and eyes and is willing to learn this so that i can apply it... Credit also goes to Pete for this outstanding discovery and generosity for sharing this knowledge...😊😊😊

[@andy.puempel]

Nicely done. Always enjoy seeing creative uses of the powerful capabilities of Excel. Your videos are always to the point and well produced.

[@LeilaGharani]

Thank you for the kind words Andy.

[@kcinplatinumgaming2598]

Good demo, I actually designed 3of9 barcode generator around 10 years ago for my self and a retail store in Manchester it was quite a powerful program had many features print labels, design a templates even read barcodes and processed stock barcodes too for stock control ect, designed in VB6 its nice to see people still developing source within VBA as most of the coding now is within Python, C# ect -- good job Peter..Nice demo Leila

[@LeilaGharani]

Wow, that sounds like a great application.

[@JeRRY-xw6xj]

Leila is a gamer. Man I was really good at VBA in college. Forgot all this now lol

[@Scott93312]

Wow, this is ridiculously simple, I wish I knew about this 10 years back, it would have made a world of difference when I started my job. It's not actually the type of Bar Code we use at my work (Code 128-B), but I imagine that the principals are the same. I think I might make a project out of this video of yours. Thank you soooo much!

[@BillingSoftwareGuru]

yes

[@001Gastik]

At code 128 the biggest problem is to calculate verification last letter of code, but I make it in excel and it works almost 100%. But there are some free barcode generators which are easy to use...

[@Scott93312]

@@001Gastik Yeah, that checksum portion of the barcode was tricky, especially when you had to consider variable lengths of possible barcodes, but I figured it out and it works like a charm.

[@aparetix]

Thank you Pete and Leila

[@dslaugh46544]

I do this all the time without VBA Leila. You just need a font (I use 3 of 9 barcode font), and a concatenate formula. I'd be happy to send you a sheet. It couldn't be simpler.

[@IronBand4]

Correct, I managed an entire test article inventory and tracked which parts were used/reused on what test articles using this method, a scanner, and a sticker printer. Much simpler than this method.

[@wackolas]

Can you explain what you mean by a font and concatenate?

[@TheNewton]

@@wackolas there are free fonts available for some barcode types, so you'd type **1234** change the style|font to that barcode font and it will turn into a barcode, like the wingding font. They use typography ligatures to turn a series of characters into another character(barcode)

[@souzafontes]

Of course there are a lot of easier apps to generate a barcode. However, the informations and contents of the video are awesome. Thanx!

[@magnushultgrenhtc]

If you only need a few of them, Microsoft Word can create barcodes and QR codes using field codes. That's another kind of learning project, I guess, but it works nicely once you get the hang of it.

[@ismailismaili0071]

thank you so much Ms. Leila and Mr. Pete it was really useful and great video to watch I really appreciate.

[@wbarker1305]

Always enjoy your videos and tips. This one was particularly interesting (and yes, fun!)

[@LeilaGharani]

Glad you enjoyed it!

[@spfspf2166]

Tanks Leila and Pete!

[@AbizerPardawala]

Your channel deserves to have a million subscribers and no. 1 trending channel on youtube

[@neilvanrooyen7196]

Thanks for the Guide... Used what was provided as a reference and did it all with only formulas and no VBA.

[@MrDanielduranc]

Wonderful, I Love the way that you explain everything. Your are the best!!!

[@LeilaGharani]

Thank you for the kind feedback Daniel.

[@MrDanielduranc]

@@LeilaGharani 😍😍😍😍😍😍😍

[@tha2irtalib343]

Great & helpful , thanks Leila & Pete .

[@AbhishekTripathidce]

Thank you LG and also Pete for sharing this nice secrete of bar code.

[@LeilaGharani]

Our pleasure :)

[@joep9617]

Like the idea that uses VBA to only update based on changes within certain cells.

[@raja.mubbasshir9072]

Really a cool gadget! Thank you Leila and Pete!

[@LeilaGharani]

Our pleasure :)

[@abobobo943]

Very good and clear explanation as usual. Thank you very much.

[@paulvanlit]

Nice video; extra tip, there are charachter sets available (free) to create the bars more easily (without VB)

[@donovanlucibello379]

Simple but elegant!

[@pushpajchougule8316]

Glad to know how barcodes are actually generated. Had to admit some part of the video has gone above my head 😂 but i am gonna take another look and also review the worksheet. Thanks Leila and Pete. You guys rock!

[@LeilaGharani]

It took a while for it to sink in for me too :)

[@hasarangaanuradha7862]

This is super stuff, Leila. I learned a lot from your youtube lessons - Thank you.

[@BillingSoftwareGuru]

yes

[@tomspallone1868]

PERFECT presentation! Wow!!!!

[@harpreetmoney]

Thank you for sharing such an informative video

[@LeilaGharani]

My pleasure.

[@mr.gardengreen7124]

Awesome Ms. Leila.. very informative

[@LeilaGharani]

Thank you! 🙂

[@ExcelForFreelancers]

Great video Leila, I learned a lot. :)

[@runwiththerunners8152]

Thank you Pete and Leila you have my admiration and respect. Such ingenuity. Leila I know I am but a man but I am totally in love with you. You are a flawless diamond! Now I am going to sign up for one of your VBA courses (hoping there is a basic one) so I can maybe try this myself. Thank you both.

[@LeilaGharani]

Our pleasure!

[@exceltech1076]

Very Good Tutorial . I like it.

[@BarcodeFreeware]

Excel data to barcode labels - you can first enter multiple barcode values in Excel, and then import them into our barcode generator software to make bulk barcode labels, this way can improve the work efficiency.

[@tutorials--1234]

3 Years ago I created an inventory application in Excel using a cordless barcode scanner to enter stock items AND control Excel (Yes, No, Retry, etc) ... combining it with the "Application.Speech.Speak" in vba the Excel app was able to provide audio feedback to the user. This was important because the stock items and the user's computer were not located in the same part of the office. I printed out a sheet of barcodes from a generic online barcode generator) for various functions such as: item brand, item category, quantity, yes, no, retry, enter, etc. If they scanned the wrong code Excel would say "that is the incorrect barcode, please try again". Once they had scanned all the details for the stock item they scanned ENTER, and Excel would confirm the entry by saying "Item has been entered". Who knew you could completely control Excel with a barcode scanner, huh?

[@LeilaGharani]

Wow, that's some serious application.

[@tutorials--1234]

It just took some out-of-the-box thinking, but it worked very well.

[@dillooshariff2452]

One more lovely and useful video with clear explanation. Thank you very much madam... greetings from Maurituis...

[@LeilaGharani]

Thank you for the kind feedback :)

[@amilcarc.dasilva5665]

Thanks a lot Leila. It's really great to follow your video tutorial. It is superb

[@LeilaGharani]

Thank you for following Amilcar!

[@TheNewton]

There are also free barcode generators that have a "url based api" online that you just visit a specific url to generate a barcode image, same thing for QR codes some are also open source so you can setup your own server. Basically set an IMAGE, or hyperlink, formula to contain your types and codes and you get an image back Google sheets example _Barcode,API URL,Type,Value,Image Type, IMAGEFORMULA,barcodegeneratorwexamplewebsite/barcode/,c39,1234567,PNG, _ With the formula for google sheets being =IMAGE(B2&C2&"/"&D2&"."&E2) When the spreadsheet fetches the image it goes to that barcodes specific url and the image gets generated then served to the spreadsheet. The caveat being if you have ALOT of codes that ALOT of images to fetch so can take a bit and some services have rate limits.

[@pierreseguin2143]

Thank you Leila. I would like to learn more about UPC Barcodes. For example returning the description, model number etc in different cells of a worksheet after having scanned a UPC of a product. (Using VBA or not)

[@sivakrishna478]

Amazing madam. Very very helpful video. You are redefining the way of doing work and business. Thanks for sharing the same

[@BillingSoftwareGuru]

very nice information

[@alanlamb6047]

OK, agreed that a Barcode font is the way to go, and that a non-VBA solution is available via some lookup creativity However, COVID 19 and isolation, so... My contribution is that it can be solved with a stacked column chart . The first series is set to no fill and just displays the category names, the second series is then stacked on top and forms the barcode. Both series have the column Gap Width set to zero. The result is a barcode as a chart that is a perfect match for the UPC Barcode and is dynamic without code. On a roll, I also achieved just the barcode based on using a Sparkline. If there's interest, I'm happy to release my completed solutions Take care, Stay Safe

[@michaeld4090]

I have been working with Label Matrix and there are 2 different types of bar code. 1 and 2 dimensional. The square ones you see contain much more data information. It is shaped like a square. You have probably seen these.

[@ricksable]

You can also use a font that prints the correct bar code for each number.

[@Tuhin360]

That is good video.. helpful

[@luisretana1690]

Great idea, this will come very handy. My only question is why VBA, this is easier done with formulas (everything is better with formulas)

[@LeilaGharani]

I love formulas too :) actually it would be interesting to use the new Excel dynamic arrays here.

[@jenniferross7901]

Thank you so much for this awesome formula and tutorial. I am not as skilled as most of the people on here, so I apologize for this question. If i want to actually use this for a product, how do I copy and paste? When I do that, it changes the UPC.

[@imranfarooq-aaa]

Wonderful video Please also make a video How to Track/insert Inventory in Excel with Barcodes Scanner

[@markdayphotography7948]

Creating inventory barcodes in Excel - that would be cool! Or barcodes for entry to events - the mind boggles. Just need to know how to get own barcodes recognised by a scanner

[@costaylor6305]

That's was great Thanks

[@ChandanSomani]

Really thank to Pete

[@helmut666kohl]

When your only tool is a hammer, everything looks like a spreadsheet...

[@CraigSenior]

It's actually useful if one needs to mock-up bar code symbols for an application without investing in any special software. While there are web sites that will do it for free, one-at-a-time, in a spreadsheet, you could do several. Interesting use of columns to generate the image.

[@LeilaGharani]

Definitely. Pete's solution is great!

[@steverolfe63]

I'm wondering how I could use this on some existing data please? For example, I have two columns of information - Name and Part Number. How could I pipe these into this spreadsheet to end up with a third column that had the barcodes for column a & b that I can then print out on a barcode printer?

[@alfarhangroup505]

Most great one I do like ur way in explaining the formula. Best wishes

[@TYoung023]

Wow. Looks exactly like something I would do. Recreating the wheel in Excel just because I can! I’ll probably be recreating this as well with a few updated functions (LET for example).

[@alielzain]

Thank you,,,, you are make Excel easy for me

[@LeilaGharani]

Glad to hear that :)

[@thetourminator]

During this video my brain could handle learning about how UPC codes are structured. Towards the end though my brain exploded when presented with the VBA array layout.....OMG that is HIGH LEVEL ADVANCED stuff.

[@masterof]

It is great to have a VBA solution. It also looks like we should be able to do it with Conditional Formatting too... By the way, I thought all bar codes are now GTIN-13 (or EAN-13), replacing the UPC-12 since several years ago? Maybe I am wrong on this.

[@shinemuzammil4270]

This cutie pie saved my day ❤️❤️❤️ thankyou very much girl

[@LeilaGharani]

You’re welcome 😊

[@DougHExcel]

Smokingly great video! Excel can do (almost) anything.

[@MJAfifi]

There is another way I've been using it for ages and it is much easier and much more simple and reliable.

[@justinemusoke2321]

Share that please

[@MJAfifi]

@@justinemusoke2321 would like to share it if she allows me. she can even explain it on a video.

[@AtroXAir]

Absolute Crazy, what smart People can do with Excel.

[@vincysigma]

Waw.. I newer knew that Excel can do this... and it was explained so detailly... Thank you so much.

[@mspetak1290]

Thanks for sharing. Never would have thought that you can do this in excel. Amazing!x Subscribed.

[@LeilaGharani]

Glad to have you here!

[@Dtigernumber1]

This video explained how to create barcode. Could you please make video on how to link product details to barcodes.. thank you

[@kapitanknuthansen488]

AWESOME INFOs AND VIDEO

[@majidsiddique8227]

excellent work for inventory

[@bijaysharma6068]

Awesome as always!

[@TheYohan1989]

Hi! I really liked your videos. Do you have video on how to create attendance + payroll for daily, weekly, bi-weekly, monthly?

[@areseses1773]

Great content ❤. I had one question though, how you know what digit or numbere you want to encode to Barcode? How do you do it what numbers you want to use !!!

[@harishnebhwani4255]

Ameging, good work , god blessed you

[@pakeezainstitute]

Excellent Work Dear ,, i'm Really impressed your work

[@eunseoklee3471]

I really like your channel. Keep up the GREAT WORK always!

[@LeilaGharani]

I'll do my best Henry :)