Scan barcode and display contents of row

[aamarb]

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

 

[Gerald Higgins]

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.

 

[TechnicalSwordsman]

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