I have a drop down list of the various items in my inventory in a drop down list. As part of an activity log, I am trying to tied the value associated with this list selection to either credit or debit the total amount of product left in the inventory in a different tab. So far, I cannot figure out how to link this value to the specific product which it corresponds to.

ex:

Column A:1-10 has the drop down list of the various products in the inventory
Column B:1-10 is where I put in the amount of product used or added to this specific selection in the list

Column A on another sheet has the running total of these products (needs to be on another sheet because I am attaching different info to this database

Does anyone have advice on how I can get this working?

Thanks