Automate barcode scanning into an inventory sheet to add to actual inventory and subtract

Good Evening All,

I am by no means very knowledgeable at Excel but I'm giving it everything I have to learn and understand it.

I would like to have two cells on my sheet that I scan into based on if I'm receiving finished goods or shipping finished goods.

If I'm receiving finished goods I would like the sheet to add to the actual inventory.
If I'm Shipping finished goods i would like to subtract from actual inventory

I would also like to know if after the inventory has changed if the cell that I would be scanning to can reset itself to scan another or if i would need to integrate a reset/delete button to scan another?

Any and all help would be very much appreciated.

Thank You

Oh, I'm late, but since I prepared a macro you can have try. Copy the macro to the 'Inventory' sheet module; it detects the event Worksheet_Change.

Please Login or Register  to view this content.

There were two people who offered help - not just one.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Can you please mark the thread as solved - instructions in my post above. Thanks.