How to create a QR Code for selective data in MS Excel

Поделиться
HTML-код
  • Опубликовано: 31 дек 2024

Комментарии • 21

  • @tristramemerge
    @tristramemerge 9 месяцев назад +1

    Thank you for this. Do you know what add ins also cater both image and text in QR?

    • @SMJTech2020
      @SMJTech2020  9 месяцев назад +1

      Hi Thank you for your comment. There are quite a few add ins for text however, to incorporate image, you'll need to use an online tool as Excel doesn't embed the image inside of its cell therefore, it is not possible to pick it up. However, if you have used IMAGE function within Excel to have the logo inside of the cell, then you can use that selection to generate QR code.

    • @tristramemerge
      @tristramemerge 9 месяцев назад

      @@SMJTech2020 i see thank you for the knowledge, planning to have my own personal ID for my students. The plan is scanning there ID and at the same time they can watch the preview to a monitor after scanning to verify attendance. I think this needs a software. 😅

  • @nuramohamed6005
    @nuramohamed6005 2 года назад +3

    Thank you.. You helped me a lot

  • @mathtoma7885
    @mathtoma7885 6 месяцев назад +1

    Thank you so much - It's really helpful.

    • @SMJTech2020
      @SMJTech2020  4 месяца назад

      I'm glad it was helpful for you

  • @raogaming3313
    @raogaming3313 Год назад +1

    If changes made in cell them can qr code generate automatically

  • @GenanDana
    @GenanDana 10 месяцев назад +1

    I want to create a barcode with info shown like company logo product info. Could you help me

    • @SMJTech2020
      @SMJTech2020  9 месяцев назад

      There's a barcode font which can be used however I'll have to check if there's a possibility of of including logos or any images since they are not usually embedded within a cell in Excel.

  • @FaceofLastDon
    @FaceofLastDon 3 месяца назад

    Hello, what version of MS the you use, mine doesn't have the same interface as yours. Thanks

  • @SudarshanKarki-n4g
    @SudarshanKarki-n4g 5 месяцев назад +1

    When I scan your QR code, data appear on the google search bar. Is there a better way of presenting of the data?

    • @SMJTech2020
      @SMJTech2020  4 месяца назад

      Thanks for your comment! When using the Google API to generate a QR code, the data is designed to be presented in the search bar by default. For a better user experience, you can modify the data in the QR code to link directly to a webpage, a Google Form, or a file (like a PDF), rather than displaying raw data. This can be done by adjusting the URL or content embedded in the QR code during generation.

  • @scanbocustomerdelightteami2914
    @scanbocustomerdelightteami2914 10 месяцев назад

    Please let me know how to attach the company logo with the QR code.

    • @SMJTech2020
      @SMJTech2020  10 месяцев назад +1

      Sure, I 'll try to cover in my upcoming video.

  • @middleeasternmediterranean4477
    @middleeasternmediterranean4477 7 месяцев назад

    What if I have 100 employees? Shall I do it one by one? Can I do it as dragging?? Thanks

    • @SMJTech2020
      @SMJTech2020  4 месяца назад +1

      Hi , you certainly can. I created another video which covers this using another function which allows the QR code to be embedded within the cell. Here is the link which will prove helpful: ruclips.net/video/T1WOdOPtJZM/видео.html

  • @NoorFatima-lz2zk
    @NoorFatima-lz2zk 2 года назад +1

    Nice