Greetings,
I am trying to keep track of inventory. I have a "starting number" in the cells on column C (50 rows of data). When an "inventory number" is entered into a cell [E, G, I, K, M, O] I want a change event to occur so that the inventory number is subtracted from the starting number in the corresponding row. For example C20-E20, or C30-M30 That will give me a new starting number.
The tricky part is that later the inventory number will be deleted, but the starting number needs to stay its current value i.e. it cannot go back up because we deleted a number. That is why I was gong to do a change event. Because when my inventory number is deleted it will subtract 0 from from starting number and no harm is done.
I have tried several different things. Here is what I have so far:
Private Sub Worksheet_Change(ByVal Target As Range)
End Sub
Thanks for the help
I am trying to keep track of inventory. I have a "starting number" in the cells on column C (50 rows of data). When an "inventory number" is entered into a cell [E, G, I, K, M, O] I want a change event to occur so that the inventory number is subtracted from the starting number in the corresponding row. For example C20-E20, or C30-M30 That will give me a new starting number.
The tricky part is that later the inventory number will be deleted, but the starting number needs to stay its current value i.e. it cannot go back up because we deleted a number. That is why I was gong to do a change event. Because when my inventory number is deleted it will subtract 0 from from starting number and no harm is done.
I have tried several different things. Here is what I have so far:
Private Sub Worksheet_Change(ByVal Target As Range)
End Sub
Thanks for the help
