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 ...
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
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
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)?
Posting Permissions
LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks