Hi all, IT Guy here, but not particularly fluent in Excel.
Boss is VERY good with Excel, but he is on vacation in Asia.
We have a system in production that does one thing: We scan a barcode for a warehouse order into Excel, and it prints a sheet of 24 stickers with only the bar code and human readable order#. We use those to peel and stick both on cartons moving between departments, as well as track orders throughout our warehouse and factories into our ERP system, so customer service cal tell at a glance which stage of production an order is in house..
I need another workstation in production ASAP.
The thing is, MR. boss man programmed the macros into the SCANGUN. I can do that too, but I would much rather do the same thing in an Excel macro so we don't have to have proprietary scan guns. I want to just grab a gun with a standard carriage return, and we're good to go.
So can I get a macro that will print the current page (and go up one cell back to the starting cell) whenever we scan an order.
The macro has to return to the original cell because the user will usually scan a 1/2" to 2" pile of orders at a time.
Thanks
Bookmarks