Tracking Inventory

Hey Excel friends,
I'm fairly new to VBA coding and would love some input on a project I am starting. I am trying to track inventory from 4 different locations. On one sheet, I have created an insert table which will record inventory moving from one location to another. I set up multiple input boxes to make it easy for the user. Now that I have a record of the product being moved I want to sum the values and have the totals appear in another sheet. I am thinking about using a sumif, but I'm not sure if that's the best option. I'm a confused on how I make a positive to one location mean a negative to the other (a give, take) type of deal. Any help would be greatly appreciated. My code for the insert sheet is below.

Thanks, John D.

Please Login or Register  to view this content.