+ Reply to Thread
Results 1 to 1 of 1

Macro for scanning QR codes

  1. #1
    Registered User
    Join Date
    01-21-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    24

    Question Macro for scanning QR codes

    Hi, I have a spreadsheet with a few hundred items on it and these items are occiasonally getting sent out and then returning to me and I want to to book them in and then out so I know what is happening.
    I currently have a tab with all of the items on it and then I have created a new tab for booking these items in.

    Ideally I would like to scan the QR code which has a unique id number and then the scan will transfer the unique id into a cell, then the next column (column 'B') to show the date and time when the scan happens, when the items returns I would like to scan the QR code again to book the item back in with the date and time (column 'C')

    I currently have a macro which works ok but I wanted it to work automatically if possible as I currently scan the QR code into cell E1 and then press control 'L', this then puts the unique id into column 'A' if not already there and the date and time into column 'B' and then if the unique id is referenced in column 'A' it will put the date and time into column'C' next to the correct id.

    Here is the macro that is generated, is it possible to change this so I can just scan the QR code putting the date and time automatically when booking in and out but keeping the information next to each other

    Hope this makes sense

    Cross posted link: https://www.mrexcel.com/forum/excel-...-qr-codes.html

    Please Login or Register  to view this content.
    Last edited by jak68; 02-19-2019 at 03:56 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 06-06-2019, 01:44 AM
  2. Scanning UPC codes and counting how many times each code was scanned
    By forestavekids in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-29-2016, 10:24 AM
  3. Replies: 7
    Last Post: 08-13-2015, 10:58 AM
  4. Replies: 0
    Last Post: 10-09-2013, 07:59 PM
  5. Scanning two bar-codes into excel and validating the data.
    By shafiahmed in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-14-2013, 04:30 AM
  6. Controlling scanning and naming of a scanned document ipdf from within an Excel macro
    By Tumushabe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-07-2012, 02:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1