By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,708 Members | 2,091 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,708 IT Pros & Developers. It's quick & easy.

How to search for a value, and move my cursor to the adjacent cell in MS Excel

P: 7
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!
Oct 12 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.