scan

Hello, I am a excel dummy and learning as I need to something different. I looked but didn't see a topic for what I am wanting to do now. At work we have a Good Parts room where we take parts from when we do a repair. Currently there is a form that we are to fill out when we take parts but most...

Hi, I need a script that will scan from E4 to last used row then G4, I4, K4 and M4 for today's date. So any row which does not have today's date in the said columns, delete them. I am stacked so I need someone pull me out. Thanks

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...

This is my issue. I am trying to scan several documents into picture form. From there I am trying to line them up so there for I can set up the page breaks for printing each page. However, the scan is 8.5 by 11, when i put it in excel it doesn't print out the same. It either prints smaller or in...

Hi everyone, I have a worksheet that accepts scanned data from bar coded cards. The records are parts to be ordered and they include their responsible buyer. I have provided additional functionality, whereby the data can be sorted by buyer, emails are sent to them with their allocated parts...

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...

Hi, We have recently purchased a barcode scanner to scan all of the products that get delivered to us and what we want to do is check against the delivery note to see if we have received everything on the sheet. What I am looking at is something along the lines of: We have a tab with an...

Hello all! I have an event that require card access to validate attendance. Note: The card scanner populates cell B2 and overwrites the same cell after every scan. <tbody> A B C D E F 1 ID SCANNER SCANNED ID NAME 2 9000 8000 BURNO 3 Y 9000 JAMES 4 5000 ADAM </tbody> When...

Hello all! I have an event that require card access to validate attendance. The card scanner populates B2 and overwrites after every scan. <tbody> A B C D E F 1 ID SCANNER SCANNED ID NAME 2 9000 8000 BURNO 3 Y 9000 JAMES 4 5000 ADAM </tbody> When there is an ID match...

So I work at a shop with a rental program we are trying to digitalize. I am pretty good with excel so I created a document that does almost everything I want. What would be nice for it to do that it currently does not is scan items in and out. Best case scenario, when an item is being checked...

Hey, there. First of all, many thanks to all the crazy-smart people that post on this board. Not gonna lie, I have creeped on this site a lot, and I've found so much help on Mr. Excel. However, I finally have a question that I've been unable to resolve to my satisfaction (and my searches through...

I have been creating a spreadsheet with Hyperlinks that link to a pdf of a scanned copy of drawings for different work orders. When a job is completed I scan the files, place them in a general folder and give it a file name which equals the WO#. I'm wondering if there is a way to create a...

I have a file that creates barcodes in a specific format. The trouble is, you can only make 24 at a time before you have to print them. I'd like to have a way that you can crate as many as needed and, as the sheet fills up, another sheet gets created and so on... You scan on 'Scan Sheet' It...

Hi, I am looking something similar to thread shown below. https://www.mrexcel.com/forum/excel-questions/672492-scan-barcode-excel-date-time-stamp-out.html. I am looking for the similar code that hiker has provided in his reply #18 but My way of arranging cells is little different and I need...

I'm sure this has been addressed before on theses boards but I figured I would try asking before searching. I work at a small children's hospital with limited resources and we need to come up with a simple inventory system. This is what I want. Another department calls for a bottle of...

If cell A1 has a number 123456 that uses the font Code 3 of 9 it will not scan, but if i put an * as the start and stop bit it will scan. my question is if cell A1 = *5* and cell B1 = *2* how can i multiple cell A1 and B1 to show up as 10 in cell C1? (cell C1=A1*B1)

I have 2 sheets in excel. 1 sheet is printed out for employee to sign and have an assigned barcode to there name. I want to scan that barcode and have it search for a match on the other sheet and highlight it. I am not using any barcode software just a usb scan gun. it will scan to the excel...

Hi Guys, I have a file and i think its become corrupted. If you click in the formula bar although the formulas seems to be ok, the text is all in different fonts and colours. Any thoughts? Is there a way to run a scan on a excel file to try and clean up any errors. Thanks