scan

Hi, I got this code by searching on internet, and i use to count my store inventory by scanning there barcodes, We scan Barcodes in H1 cell, it searches that if barcodes list i pasted having the scanned barcode it increases the quantity of that item, if we scan a new barcode(not in pasted...

I am stumped! I am trying to figure out a formula and it is jut not working. I am working with SKU's and UPC's. Where I work I am dealing with product that has either a SKU or a UPC on it, and I am currently in the process of having to verify where product is in the warehouse. What I am needing...

Hi All, I have been trying to wrap my head around how to write this, but I need help. Basically, I want to scan a large set of data (mostly dates) and return upcoming data + their respective tasks. The tricky thing is that I don't want to return tasks that are already "done". Below is a sample...

I use to have a spreadsheet setup where when I scanned in the barcode inventory it would delete the item from the list. I have lost the sheet now I want to re create it. Can I use a macro? You help would be appreciated. Thanks

Hi, i was wondering if anyone knew how to or if it is possible to set a scanner to scan barcodes into a specfic sheet, column or row in excel whole cursor is on another? Meaning you would set the scanner to scan the barcode in spot and could be working on the document somewhere else - currently...

Problem: I'm trying to use a USB barcode scanner to scan a barcode into excel and autoprint the number value. Is there a simple efficient way to do this using excel? If not what can you suggest? I've trawled the net, but keep being sidetracked to irrelevant avenues regarding stock/barcode...

Hello, Situation: Accounting database that needs to be matched based on the last two columns. Any unmatched rows are manually fixed. <tbody> A B C D E F G H I J K L Type Nbr Post <tbody> Auto Rev </tbody> <tbody> Nbr </tbody> <tbody> Nbr </tbody> <tbody> Date </tbody> <tbody>...

I hope I am asking in the right place. Also this is some how related to Excel not completely. My task: I have 5 paper forms. I have all my database inside an excel table sheet. I have to fill 5 forms for each record. I have constructed 2 of the forms in 2 different sheets in the same...

I'm trying to create a dynamic "Class Schedule Planner" using Excel 2007. Column A has non-uniform time intervals ranging from 6:00 AM in A3 to 10:15 PM in A58. Column B2,C2,... to H2 has labels for Monday to Sunday. For a given Day such as Monday in B10 to B15 I have a class name and...

I need to scan hundreds of archived workbooks in a given folder to find a specified value on the "Radio" worksheet (in column B). In the same row, coumn D is where it was used, Coumn E is the User Serial Number, and Column F is the User Name. Ideally, I'd like to create a simple excel form...

Hi All First time poster here, but I've gotten a lot of useful advice just from searching the boards in the past. I have what I hope is a simple question: How do i set up code so that when I scan a barcode, rather than return that value, it searches the sheet for that value and brings me to...

Column E contains year data. While column J contains some dates and some cells are empty in this column. I want to look in column J and count the number of each year (there are many years in column E) for all the cells for which cells in row J are empty. Then I want to scan the range from...

Hello, I have a text report that I get every day. It is a few hundred pages long but I only need 10% of that information. Below is an example of what the text file looks like when I copy/paste it into Excel. Sorry if it looks sloppy, wasnt sure how else to paste the excel dummy info in. So...

I thought there might have been a post about this, but I've been searching for about 2 hours with nothing. I'm using Excel 2007 (compatibility mode 97-2003). I import a table of numbers that appear in column A. They look similar to this (999-9-9-00). I need a complex conditional format in...