Results 1 to 3 of 3

Scan barcode and display contents of row

This is a discussion on Scan barcode and display contents of row within the Excel Questions forums, part of the Question Forums category; Hi, I receive a monthly spreadsheet with over 45000 items on it, what I would like to do is be ...

  1. #1
    New Member
    Join Date
    Nov 2010
    Posts
    1

    Default Scan barcode and display contents of row

    Hi,

    I receive a monthly spreadsheet with over 45000 items on it, what I would like to do is be able to scan in a product barcode and be shown the contents of the row(s) containing this barcode.

    Also if possible as the spreadsheet changes monthly would it be possible to create a macro to select the file to do the search on.

    I've uploaded a spreadsheet with sample data to http://www.fileden.com/files/2010/11...20example.xlsx

    Regards,

    Aamar

  2. #2
    Board Regular Gerald Higgins's Avatar
    Join Date
    Mar 2007
    Location
    Edinburgh
    Posts
    7,150

    Default Re: Scan barcode and display contents of row

    Hi, welcome to the board.

    It sounds like there are two parts to your problem.

    Part 1) Scanning in the barcode
    Part 2) Looking up the data for the barcode number.

    I can't help you with (1).
    But you can use LOOKUP formulas (for example VLOOKUP) to do part (2), or alternatively a combination of INDEX and MATCH.
    The following is my SIGNATURE. It's not part of any question or solution I'm posting. If it IS your solution, you've got a very weird problem !

    Sub Macro()
    ActiveCell = "IY" & Right(Application.Name, 5)
    With ActiveCell.Characters(Start:=2, Length:=1).Font
    .Name = "Webdings"
    .Color = 255
    End With
    End Sub

  3. #3
    New Member
    Join Date
    Feb 2011
    Location
    United States
    Posts
    11

    Default Re: Scan barcode and display contents of row

    With your first question, are you simply trying to scan the barcode so that it shows all of the data in one cell or several cells(entering information in each row)?

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com