Transfer barcode info to inventory quantity
Solved/Closed
Related:
- We couldn't find an account matching the login info you entered
- How to transfer info from one excel sheet to another - Guide
- HUGE Inventory Assistance - duplicate a row based on a cell value or quantity ✓ - Forum - Excel
- Can we transfer free fire account from facebook to google - Guide
- Confirm your info on the app - Forum - Instagram
- Confirm your info on the app instagram - Forum - Instagram
1 reply
shootingfish
Mar 21, 2011 at 03:22 PM
- Posts
- 14
- Registration date
- Sunday February 6, 2011
- Status
- Member
- Last seen
- September 1, 2011
Mar 21, 2011 at 03:22 PM
I have limited experience of retail Point of Sale systems, but I think i have seen something that might be of use to you.
Barcode scanners that interact with excel are usually programmed to enter the code in the active cell and then "press enter" so to speak so that the next cell down is selected. I guess this is how yours is working too. The retailer using this had two workbooks, a sales sheet and an inventory and so long as they were both open at the same time the inventory was being updated on a live basis.
It used a macro that was attached to the "press enter" event. It would effectively look at the number that had just been entered and count the number of instances of it in the list. Then it would match the code with the list of codes in the inventory sheet. Predictably, the next step would be to subtract the countif result from the inventory number.
Is this the kind of Macro that you would need or am I getting the wrong end of the stick?
Barcode scanners that interact with excel are usually programmed to enter the code in the active cell and then "press enter" so to speak so that the next cell down is selected. I guess this is how yours is working too. The retailer using this had two workbooks, a sales sheet and an inventory and so long as they were both open at the same time the inventory was being updated on a live basis.
It used a macro that was attached to the "press enter" event. It would effectively look at the number that had just been entered and count the number of instances of it in the list. Then it would match the code with the list of codes in the inventory sheet. Predictably, the next step would be to subtract the countif result from the inventory number.
Is this the kind of Macro that you would need or am I getting the wrong end of the stick?
Mar 22, 2011 at 12:33 PM
http://www.mrexcel.com/forum/showthread.php?t=477285&goto=nextnewest
What you are talking about though is sort of what I was looking for except I wanted to both add and subtract 1 from the inventory utilizing two different cells.