Excel 2007 : Barcode Inventory Sheet

Bump!! Bump!!!

Originally Posted by bigstef

Bump!! Bump!!!

Search BARCODE INVENTORY -- see the thread I started. If you want an updated version, I've got it pretty functional now (standalone).

Cant see the post you are talking about. Searched for your sheet but found this one instead now.
http://taltech.com/files/Inventory.exe

Just need a bit of help to do one quite important thing with the sheet.

When adding 1 item to stock, you scan the barcode then press done and it adds one to stock. Or if you prefer it can also take one off stock by the same process, scan the barcode then press done.

What I need to do with this sheet is when I choose to scan my inventory I would scan the barcode, but instead of pressing done I would prefer the sheet to add one to stock automatically then clear the input box ready for me to scan the next item. That way when doing an inventory stock check I just need to keep scanning products to add them to my stocks sheet.

I am sure this should be easy for all the experts here but I just havent got a clue how to amend this sheet to do this.

Any help is very much appreciated.
Thanks, Steve

Bump

Any help with this please.

Bump again.....

Another week another bump!!!

Guess what???


Bump