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.

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
    Dim item   As Variant
    Dim srch   As String
    If Target.Cells.Count > 1 Or Not Target.Address = "$B$1" And Not Target.Address = "$B$2" Then Exit Sub
    If Target.Value <> "" Then
        Application.EnableEvents = False
        srch = Target.Address
        Set item = Range("A6", Range("A" & Rows.Count).End(xlUp)).Find(Range(srch).Value, LookAt:=xlWhole)
        If item Is Nothing Then
            MsgBox Target & " is not inventoried."
            GoTo exitcode
        Else
            Select Case srch
                Case "$B$1"
                    item.Offset(0, 8).Value = item.Offset(0, 8).Value + 1
                Case "$B$2"
                    item.Offset(0, 8).Value = item.Offset(0, 8).Value - 1
            End Select
        End If
exitcode:
        Set item = Nothing
        Range(srch) = ""
        Range(srch).Select
        Application.EnableEvents = True
    End If
 End Sub

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.