Excel Ranger
Board Regular
- Joined
- Oct 31, 2005
- Messages
- 54
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
I'm utilizing an older COMPAQ H3900 iPAQ with a SYMBOL SPS3000 Scanner expansion pack for tracking issues or inventory in a warehouse. I'm running on Windows XP with Office 2003. I have the VLOOKUPs all set up so when I scan a barcode, it drops the value in the A column. The other column values (i.e. stock number, manufacturer, serial number, price, shelf location, etc.) autofill across the other columns based on the VLOOKUP of the scanned value, based on the inventory sheet on a seperate tab. The problem that I am having is that I'm dealing with 2 barcode formats. The older system had a letter (A-L) plus 4 numbers (example L1234). We recently switched over to a new logistics system which uses a 6-digit barcode instead of the older 5-digit format. In the interim, a zero was placed at the beginning of the older numbers, so L1234 became 0L1234. The new system is gradually replacing all of the stickers, so eventually it will be 6 numbers, instead of a letter plus four numbers. Now what I'm trying to do is set the formatting to read a number like L1234 as 0L1234. The second part of the problem is that the new stickers, when read, incorporate an accounting code with the new number. So when I scan a new sticker, it might read 000789WK4FN. I just need the first 6 characters.
Anybody care to tackle this one? No VB, please. I had enough trouble with C++ and Java!
Anybody care to tackle this one? No VB, please. I had enough trouble with C++ and Java!