36 پاسخ به “چگونه می توان بارکدی را در Excel ایجاد کرد که WORK است!”

1. I would like to learn more about barcode

2. I downloaded it and opened it and it seemed to work, however the barcodes were wrong.The numbers matched, but the stripes looked all wrong. ???

3. 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 asterix&what you write&an asterix (eg.. *hello*) Change the default font in this cell to Code39. Voila! (note: the asterixs tell the scanner where the real text starts and ends). This font is available in any program (excel, powerpoint, word, etc)

4. This woman is so amazing. It's hard to meet a tech girl, much less one who does so much to help people.

5. Is it possible to make Code 128 barcodes in Excel like this?

6. I'm always dissapointed when VBA is used when normal excel functionality could have done the job. For shame.

7. This is great idea. Congratulations

8. Hi Leila Gharani

   Have you ever tried for calculating the exact age/date difference? The builtin datedif() function is not as much exact/good as that of the windows calculator. To overcome this problem, I got an excel file from my colleague that uses UDFs (see the link below) that matches my requirements. It also shows a few problems with the builtin datedif() function.

   https://www.dropbox.com/s/uz0qfkihemc7we4/Date%20Difference%20Calculations.xlsm?dl=0

   I am sharing this file for information that can solve the problems of many people and would like to know your views and your ideas of alternate calculations if any.

   That's it.

9. 9MX001-00L-NVY 2
   9MX001-00M-NVY 4
   9MX001-00S-NVY 9

   9MT001-00L-BLK 0
   9MT001-00M-BLK 2
   9MT001-00S-BLK 1

   this is my type of data i want to audit my shop. now these are two articles which place on products price tags i will scan it on excel sheet. now i want excel has to count the same articles and write the quantity in other colum and row of article. after this i want to compair the all data with other excel sheet which has these type off data and write the difference in other colum and row of articles. [ mean if other sheet has (9MT001-00L-BLK = 3 pcs) and i scan 2 pcs then write (-1) in diff colum and row of 9MT001-00L-BLK ]. plz make a video or send me the sheet. My Email: Armanmirza5553@@t. My whatsapp: 923362764444 . My name: Aqib Mirza

10. 9MX001-00L-NVY 2
    9MX001-00M-NVY 4
    9MX001-00S-NVY 9

    9MT001-00L-BLK 0
    9MT001-00M-BLK 2
    9MT001-00S-BLK 1

    this is my type of data i want to audit my shop. now these are two articles which place on products price tags i will scan it on excel sheet. now i want excel has to count the same articles and write the quantity in other colum and row of article. after this i want to compair the all data with other excel sheet which has these type off data and write the difference in other colum and row of articles. [ mean if other sheet has (9MT001-00L-BLK = 3 pcs) and i scan 2 pcs then write (-1) in diff colum and row of 9MT001-00L-BLK ]. plz make a video or send me the sheet. My Email: Armanmirza5553@@t. My whatsapp: 923362764444 . My name: Aqib Mirza

11. 9MX001-00L-NVY 2
    
    9MX001-00M-NVY 4
    
    9MX001-00S-NVY 9

    9MT001-00L-BLK 0
    
    9MT001-00M-BLK 2
    
    9MT001-00S-BLK 1

    this is my type of data i want to audit my shop. now these are two articles which place on products price tags i will scan it on excel sheet. now i want excel has to count the same articles and write the quantity in other colum and row of article. after this i want to compair the all data with other excel sheet which has these type off data and write the difference in other colum and row of articles. [ mean if other sheet has (9MT001-00L-BLK = 3 pcs) and i scan 2 pcs then write (-1) in diff colum and row of 9MT001-00L-BLK ]. plz make a video or send me the sheet. My Email: Armanmirza5553@gmail.com. My whatsapp: 923362764444 . My name: Aqib Mirza

12. Honestly, I've been using barcode font for this task. IDautomation something like that.

13. I don't have a use for barcodes but this video is very cool.

14. Could you please tell me how to make your company daily using Material sheet in Excel look more attractive

15. Mod-oo-loo?!?! It’s mod-you-low or modjulow. 🤦🏻‍♀️

16. THIS IS SO COOL

17. mega Leila – have a great weekend

18. Wow! Interesting. What’s next? A QR code generator? 🙃

19. Too complicate there are other away easy options to do that

20. Hey I have an Acer Predator Helios too 🙂

21. how to create bulk barcode Ean upc for graphic software ???????

22. 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.

23. Hi! Can you teach us how to create database for teacher's records using excel?thanks

24. Hi, Leila, just sharing a solution other people could find useful: everyday I have to access a pdf archive, whose name/address changes with the date. Here is the address:
    http://bvmf.bmfbovespa.com.br/download/BOLETINSDIARIOS/bd_07_20200206.pdf
    The last numbers before the ".pdf" are the date in a yyyymmdd format. With the folowing formula I am able to autogenerate the hiperlink with no typing on the browser;
    The formula that solved for me was:
    =HIPERLINK(CONCAT("http://bvmf.bmfbovespa.com.br/download/BOLETINSDIARIOS/bd_07_";TEXTO(HOJE();"aaaammdd");".pdf"))
    I had to use the formulas in portuguese, but they are hiperlink, concatenate, text, today.
    Maybe this can help somebody or give you an idea for a future video.

25. 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!

26. That's cool. Thanks for sharing

27. If I have more than 12 digits in a barcode, how can I get this???

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

29. Hi Leila,

    Thanks for sharing your amazing excel tricks. I need your help very urgent. Earlier I was using Excel 16 on Windows 2007 but now I have to use Excel 16 on Windows 2010. Surprisingly since I have moved to Windows 2010 I am not getting combine and load button in Excel power query.

    I have searched hundreds of videos to find the solution to combine the files in a folder and extract data out of it but everything fails.

    Please please share a video of the same as I have to combine 45 files twice in a week to prepare team data and right now I have to use power bi to combine the files and then copy the table in Excel.

    Lots of love
    Ashish

30. Hi Leila, thank you for your Video! It gave me a great idea on how to do this without VBA, this is how I did it:
    https://bit.ly/2Sa1UQZ

    And also for the Mod Function, I used some Array formulas so it woudn't be that big 🙂

31. Is there any way of displaying formula in excel like math equations. I know the insert equation option in excel but I want to display formulas which change according to the condition. EG : =if(A1 = " AISC " , "sqrt(b/a) " , "y^6/(H+C)". I was also thinking of creating charts to display formula on them with conditional formatting but i really donot know if I could write math equations on it .

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

33. CAN YOU PLS PLS DO ALSO QR CODE

34. But why not just use the barcode font? Does the same thing.

35. It’s very much complicated, there is a very very easy formula to create a scannable Barcode.

36. Great tool and as always perfect explanation by Leila.
    I prefer to limit as much as I can the VBA/macro use, in order to keep things simple.
    Therefore I modified the original file by using index and match for generating the barcode without VBA.
    If someone is interested, I can post the link to my barcode generator without VBA.

نظرات بسته شده اند.