barcode

This is my first time posting so not sure if Iam doing this right. I want ascan out/in system for scanning items out and back in again with a time stamp,below is what I have a the moment LabelCode Time Out Time In 0615W 05/02/2019 11:00...

Hi Introducing myself, my skill in Microsoft excel is very basic. So my codingskill is minimum to zero. But I want to help an NGO to create a simple system to track collection Tin time In andOut, for their yearly event. They have been performing this event for decades,and is doing this all old...

Hi, I have a system where the user scans a barcode into a textbox and it returns data from another workbook. The problem is that the barcode will either be 8 or 13 digits in length. If i put the code in Textbox_change event, the code will trigger for each number and therefore will always try...

Hi, I'm quite new in all of this and I came in front of the wall. I have one .xls with a macro that by entering the data and refreshing retrieves the required data from the database. Macro is doing the refresh. We can write more data (example: multiple contract numbers) and by clicking on the...

On sheet1 I have product lists along with all the details and unique barcode. On sheet1 "barcode" column is "A" and "stock quantity" column is "E". On sheet2 "barcode" column will be "A" for scanning the barcodes and available "stock quantity" column will be "B". what I want is whenever I...

Hi Guys, Is there any possible way on excel, where i can have multiple sheets filled with information, and where i can have a barcode on each sheet, The needed is a program where i can just insert the barcode or the reference number in a cell and get directed to the sheet with the similar...

I have an excel sheet and one column has a series of numbers that make up a barcode for a particular product. My problem is that each of these barcode numbers has forward slashes within them (eg: 123/45/678/910). In order for me to process the numbers I need to remove these characters as my...

Hello, I have built a very basic sheet to monitor sales at an event we are running, almost a bit like a till system. We are scanning barcodes which will represent products and then a final barcode to "end the transaction" which can also count the number of transactions. What I'm trying to...

Can someone help me with a vba with input button - where an employee can enter their ID#, press Next, Enter the Item/Barcode#. for each item they enter, Excel will compare it to Column A, and change the Column F(Location) to the associated name of ID# <tbody> Barcode Case Name Property Email...

Hey all, I'm trying to take text in one column and have it spit out a barcode in a second column. Doing some searching, I've realized this might just be a font issue. Am I right, and where can I get the font (preferably free) to install on a Mac? Is there a formula for changing fonts in a...

Can someone please help me on this or at least show me the link on how to get started? I am thinking of going paperless with check in and check out through excel + barcode scanner. So right now I have a master list of all the cases we have in the office. My idea is to first type in their...

Hi All, I have a barcode scanner which I use to scan information directly into cells and it works great. I have created a Userform with a Textbook but when I try to scan some barcodes with the same barcode scanner into the textbox nothing happens. Do I have to change some properties of the...

I just received a bluetooth barcode scanner, and I'm having an excel-specific issue with it. I purchased the scanner to quickly enter student IDs, which have a Code 39 barcode on the back. Translated, the barcodes all begin with the letter S, followed by 8 digits (S00012345). Here's the...

Hi, I have Excel sheet with some Marcos and data table where value from barcode scanned by handy scanner is splitted into two cells (generalny last char). Does this issue can be caused by some way by Excel or should I looking for problem only with my equipment? Is it possible that...

Hi, I am developing bar-code reader by VBA but i have some issues, any one can help me. A. I have 8 textbox in a userform1 1. Barcode 2. Brand 3. Size 4. Length 5. Height 6. Width 7. Weight 8. Crop I want to scan a bar code in barcode (Textbox) and how can use vlookup type formula in all...

Is there a way to return to a CommanButton after entering data? I am matching a barcode to a column of data, it automatically moves to the next column and enters a time/date stamp then moves to the next column for manually entering a sample weight. After entering the sample weight, I would...

I am guessing that this topic has been addressed in the past. If anyone knows of where I can find the information that I seek I would greatly appreciate it. I keep my inventory in Excel Column A is a list of numbers that are unique that are also associated to the barcode on our boxes I have a...

Hi, A barcode scan currently moves down to the cell below. Is it possible to do this with VBA? A2: Contents of barcode scan is entered here B2: Scanned time placed here C2: Cell selected for user input I know you can change cell direction in options but this affects all spreadsheets...

Hi, I'm a pharmacy student trying to set up a scan logging system. I have a barcodescanner, computer and label software. I have a excelfile (database) with information about medicines, with all the information about the medicine in one row. So like this: aspirin| product code 12345| barcode...

Basically I have several spreadsheets with list of guests that will be attending a event. <tbody> IDENTIFICATION NO. NAME ATTENDING? REGISTERED? TIMESTAMP <colgroup><col></colgroup><tbody> A1234567B </tbody> <colgroup><col></colgroup><tbody> JOHN SMITH </tbody> YES...