+ Reply to Thread
Results 1 to 9 of 9

Scanning barcodes not bringing up corresponding data in the table

  1. #1
    Registered User
    Join Date
    07-02-2014
    Location
    South Africa
    MS-Off Ver
    2010
    Posts
    5

    Question Scanning barcodes not bringing up corresponding data in the table

    Hi... I have found this site very helpful, so I signed up.

    I just need help to get my data table to respond with the correct CODE for the relevant BARCODE in my sheet.
    But it only does it if the BARCODE is scanned in the same line as the table ?
    That doesn't help me. When I scan a barcode , I need the adjacent cell to display the CODE for that barcode no matter where it is scanned in clolumn E. I hope I am making sense. Please assist.

    Screenshot HERE

    Thanks

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Scanning barcodes not bringing up corresponding data in the table

    Sorry can you attach a sample sheet showing what you are trying to do, that screenshot is blocked.

    Are you trying to get the barcode details from a lookuptable?
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Registered User
    Join Date
    07-02-2014
    Location
    South Africa
    MS-Off Ver
    2010
    Posts
    5

    Re: Scanning barcodes not bringing up corresponding data in the table

    Ok... no problem
    see attached... if Excel is able to populate the Code field correctly when i scan a barcode...i will be extremely grateful...

    http://filegooi.co.za/get2/fd7cd0408...able_test.xlsx

    Thanks

  4. #4
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Scanning barcodes not bringing up corresponding data in the table

    Thats still blocked, can you click go advanced and attach the file that way. I work for an FS company, everything is blocked!!!! :o)

  5. #5
    Registered User
    Join Date
    07-02-2014
    Location
    South Africa
    MS-Off Ver
    2010
    Posts
    5

    Re: Scanning barcodes not bringing up corresponding data in the table

    ok... here we go...
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Scanning barcodes not bringing up corresponding data in the table

    =VLOOKUP(E3,Table1,2,0)

  7. #7
    Registered User
    Join Date
    07-02-2014
    Location
    South Africa
    MS-Off Ver
    2010
    Posts
    5

    Re: Scanning barcodes not bringing up corresponding data in the table

    Excellent -Thanks! - I'm busy with Excel for Dummies - Wow, couldn't believe it was that simple.

  8. #8
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Scanning barcodes not bringing up corresponding data in the table

    What you were doing was correct, in a way, it was an array formula, ready your book 1st though :o) As you hadnt committed it properly it was only checking the top line. Good way to think about formulas the way you did though, keep that in the back of your mind, that is the way they work better, so a common Qty x Price = Total for 10 rows, would be ={((a1:10)*(b1:10))} Excel only reads that as one formula, so using that will make your workbook open and recalc faster, but read your book first.

    Sorry if ive confused you, you just seem to have a good inituative way with arrays.

  9. #9
    Registered User
    Join Date
    07-02-2014
    Location
    South Africa
    MS-Off Ver
    2010
    Posts
    5

    Re: Scanning barcodes not bringing up corresponding data in the table

    Great... I am able to scan a whole box of different items now , without having to lay them out on a table in groups first.

    Regards
    Lance

+ 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. Scanning barcodes not bringing up corresponding data in the table
    By eggshall in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-02-2014, 07:54 PM
  2. Jump cells after scanning barcodes
    By odie81 in forum Excel General
    Replies: 0
    Last Post: 11-06-2013, 01:02 PM
  3. Scanning barcodes into Excel
    By andyddickey in forum Excel General
    Replies: 1
    Last Post: 11-08-2007, 04:31 AM
  4. [SOLVED] Scanning barcodes into a worksheet
    By skid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-07-2006, 09:10 AM
  5. Scanning Barcodes into Userform
    By gti_jobert in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-11-2006, 06:57 AM

Tags for this Thread

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