Hi there legends!
I'm trying to build a spreadsheet to manage logistics information. The information will be captured through a barcode scanner. I've already played around with the scanner and it records the information into a cell in excel, but I would like it to be more automated.
I need...
Hello,
I am looking for some code that would allow me to use a bar-code scanner to create a simple inventory. I work in an office with a high degree of check-in/check-out activity for inventory, and being able to simply scan items in/out would be a big help.
Consolidating that data has been...
Hi,
I want to barcode scan time in & out of the employees (from an existing list) as and when they come & go. And at the end of the month want to calculate the total number of hours they have worked. I Will be issuing them with a card containing a unique id, their names with the barcode of the...
I am new to using excel and was hoping someone would be able to help. I am wondering if there is a way to scan a barcode into excel and the have excel recognise it and count how many times the same barcode had been scanned. So basically have 3 columns Barcode, Product name and Quantity.
Hi guys,
I am looking to optimise my product check-in and out system by investing in a barcode scanner and using it with Excel.
I would appreciate some help by having a macro running on my spreadsheets. I have an enormous list of barcode numbers, and all the associated details for ranges of...
Greetings,
I am using a bar code scanner and student ID cards to track my students jogging lap times.
I am trying to create an Excel formula to record and organize their times but I cannot figure out how to set up it up where if I have already scanned one student, their ID number isn't scanned...
I will admit I am not a excel savvy person, so I could really use some help. Currently all of my inventory is saved to an excel 2010 spreadsheet, about 162 items. Each item has an ID number & description. Also on the spreadsheet are the quantities in my 2 locations and lastly the unit of measure...
Hi,
I'm totally new on excel and on this forum. But I would try to be the most specific as I can. I use to have a small store where I could keep record with a normal simple excel sheet. But it has come to a point where i think i have to create macros or program with VB. My problem is I have...
Hello
I have a barcode, containing special chars, like tab and enter. In notepad, the reading looks like:
but in excel, it looks:
How do I control the tab <tab> key from the barcode to jump next cell in Excel?</tab>
I am a records management auditor, I recently switched to using Excel from other programs and I am hoping there is a way to make my life easier,
What I want to do is scan a barcode with a barcode scanner and have it find the barcode in my Excel workbook, and then populate a cell a few columns...
My office is trying to go paperless with our hunting program and issue ID cards with bar codes. I'm trying to have a barcode scanner be able to scan the ID card and pull up their information in excel or access. How can I do this? My boss doesn't want to spend $12,000 on a full setup of software...
hi
can any one help me i need a way of taking a col of bar codes deleting duplicates and all so adding them up like this
<table border="1" cellpadding="0" cellspacing="0" width="368"><colgroup><col style="mso-width-source:userset;mso-width-alt:6436;width:132pt" width="176"> <col...
We are using a scanner to input a barcode number into "Find What" box in find and replace in excel. Is there a way to make it stay highlighted for the next input without having to use the mouse to double click to re-select after each input?
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.