ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   barcode macro (https://www.excelbanter.com/excel-worksheet-functions/118655-barcode-macro.html)

Joe OE

barcode macro
 
I am looking for a free macro that takes an input from a barcode reader and
searches a Excel spread sheet and goes to that line and waits for input. I am
trying to correct an inventory that is in sad shape. Thanks for your help.

Thomas Lutz

barcode macro
 
You basically need a Lookup macro that will search down a column to
find your bar code numbers. The following page on our web site has a
sample Excel "Inventory" example that contains the code that you need.
http://www.taltech.com/freesoftware/fs_sw.htm

Look for the "Basic Inventory Tracking Example" on the above page.

On Mon, 13 Nov 2006 14:01:03 -0800, Joe OE <Joe
wrote:

I am looking for a free macro that takes an input from a barcode reader and
searches a Excel spread sheet and goes to that line and waits for input. I am
trying to correct an inventory that is in sad shape. Thanks for your help.



All times are GMT +1. The time now is 06:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com