Excel 2007 : Barcode Inventory Sheet

I am looking for help with a workbook to keep a basic inventory list.

What I would like is to be able to use my scanner to scan an item into and out of stock, possibly by using a Userform or something similar.

I want a basic workbook inventory that has the usual things...barcode, item number, item name, quantity

When I sell an item I just want to scan it as I pack it and it takes it off my sheets or when I get stock in, I scan an item and it adds it to my sheets.

Over time I would like it to grow to be able to show whats sold on each product, when it was sold, and so on.

Any help would be very grateful indeed.

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.....