+ Reply to Thread
Results 1 to 3 of 3

Convert barcode into content automatically?

  1. #1
    Registered User
    Join Date
    10-16-2017
    Location
    Ohio
    MS-Off Ver
    365
    Posts
    2

    Unhappy Convert barcode into content automatically?

    Hello all,

    I am looking to use excel as an inventory tool. I would love to scan a barcode, and excel automatically looks up the item and transposes the results into another field so I have information about the product beyond a simple barcode.

    With smartlookup, it is able to look up the barcodes and tell me the product, but is there anyway to get that done within the sheet itself?

    If this is not possible, are there any sites, apps, or whatever that is able to do this?

  2. #2
    Forum Expert
    Join Date
    10-02-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1,222

    Re: Convert barcode into content automatically?

    Typically the barcode in Excel is just a font. If you have that value elsewhere (like on another sheet with corresponding info) its just a lookup using the scanned barcode as the lookup value.

    If your using an addin for the barcodes (I have no idea what smartlookup is) then you may not be able to do this and should refer to the add-in creator.

  3. #3
    Registered User
    Join Date
    10-16-2017
    Location
    Ohio
    MS-Off Ver
    365
    Posts
    2

    Re: Convert barcode into content automatically?

    I apologize, I should have made this clear:
    When I scan a barcode, it shows up in a cell as the numbers. For example: 8441710053

    When you right click on a cell, there is smartlookup. It will search the web for what you put in this cell, and show you results. I would like those results in a cell automatically

+ 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. how to convert a number to barcode
    By roofi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2015, 05:59 AM
  2. Automatically copy cells content based on the content of another cell.
    By chrisbarlow1984 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-01-2014, 11:13 AM
  3. Convert a number in excel to a barcode
    By Merlin54k in forum Excel General
    Replies: 1
    Last Post: 03-03-2009, 05:09 PM
  4. [SOLVED] Convert My Data into Barcode 128 B
    By Safi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-09-2006, 02:29 PM
  5. [SOLVED] Convert DATA into BARCODE 128 B quickly
    By Safi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2006, 08:30 AM
  6. Convert Data into Barcode 128 B
    By Safi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2006, 03:50 AM
  7. [SOLVED] Convert arial text field to barcode
    By bob engler in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-07-2006, 03:35 AM

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