It's quite simple what I need to do, but for some reason the process is escaping me! IF I could use Access, I would be relaxing with a cup of coffee by now...
I use a barcode scanner to log our fire extinguisher checks at this facility (we have hundreds of them to be checked monthly). I want to place a "Location" number and an "Extinguisher" number barcode. The goal is to be able to walk up, do the visual inspection, and then quickly scan the location, and scan the extinguisher. The scanner uses Excel Mobile, and I load the sheet from my PC for it to work from. It's important that the person using the scanner NOT have to find and tap a cell before each scan.
I figure that if I scan the location (which will be listed under column "A" on the sheet as a numeric value corresponding to the barcode), have the scanner input that number into a cell, search for the matching number in column "A", and then deposit the cursor into the cell just to the right of that... Then my next scan (the Extinguisher's numeric value/barcode scan) is placed in that cell, and the cursor returns to the original cell.
It would be lovely if the date/time would go into column "C" before returning, but I don't want to push my luck.
Even if someone could give me a starting point, I would really appreciate it! Part of my fear is that the Excel Mobile version cannot handle VBA - but I won't know until I try it, right?
Thanks in advance!