Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Highlight Range - wrong macro, please edit. | Excel Worksheet Functions | |||
Create Excel macro for barcode output | Excel Discussion (Misc queries) |