+ Reply to Thread
Results 1 to 3 of 3

Using a barcode with Excel

Hybrid View

Asheswillfall Using a barcode with Excel 02-26-2016, 09:23 PM
mrice Re: Using a barcode with Excel 02-28-2016, 04:29 PM
scottiex Re: Using a barcode with Excel 02-28-2016, 04:29 PM
  1. #1
    Registered User
    Join Date
    02-26-2016
    Location
    USA
    MS-Off Ver
    2010
    Posts
    2

    Using a barcode with Excel

    Hello there,
    I work in a Marine science lab. We have thousands of samples inputed into an excel spreadsheet. We are looking to somehow use a barcode scanner to scan a barcode on the outside of a bucket containing 30+ samples, and time stamp that those samples in that bucket were checked at that date.

    If you could please help me figure out how to set this up, what I must buy, etc, it would be much appreciated!

    Cheers!

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Using a barcode with Excel

    A keyboard wedge bar-code reader acts just like a keyboard and would be a good choice.

    Once the bar-code has been entered into the selected cell, an event drive macro could then look up the appropriate rows and insert the current date time using the Now() function.

  3. #3
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,347

    Re: Using a barcode with Excel

    If you have one of those scanner guns you just plug it into the computer and you can scan the barcode number to a cell in excel.
    then you can have a simple macro to record the time that it was scanned and any other similar information you need.

    As far as I can tell it is pretty straightforward we don't need to install anything on our computers before using our guns as far as i know.

+ 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. barcode and excel !
    By Joyce Yuen in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-31-2015, 10:26 PM
  2. Using a barcode scanner with excel
    By Fred45 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-10-2013, 09:23 AM
  3. Barcode scanner in excel
    By amir8000 in forum Excel General
    Replies: 1
    Last Post: 06-03-2013, 08:30 PM
  4. Barcode scans into excel
    By ReedT in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-10-2012, 05:29 PM
  5. Replies: 1
    Last Post: 12-18-2011, 12:32 PM
  6. [SOLVED] barcode in excel
    By katrien in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2006, 02:25 PM
  7. How to create barcode in excel?
    By mooscar in forum Excel General
    Replies: 0
    Last Post: 05-24-2005, 11:01 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