I've been asked by our warehouse guy to help him with an excel spreadsheet to increase his productivity. The problem is, I'm not what you would call an "excel expert". What he wants sounds very simple, I'm just not sure how to do it ...so here goes.
Right now he has a usb barcode scanner. When he scans to an excel spreadsheet the default action after a scan is that it moves down one cell. So, if it's in cell A1, it moves down to B1. What he needs it to do is move in this sequence when he scans: A1,A2,B1,B2,C1,C2,D1,D2 etc all the way down the page. The reason for this is he needs the part and lot number right next to each other. If someone could help me with this I would be eternally grateful. Thanks!
