Scan barcode and display contents of row

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Scan barcode and display contents of row

  1. #1
    New Member
    Join Date
    Nov 2010
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    8,426
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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)?

User Tag List

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