Running Total for tracking Inventory

[CJBaird]

Hi everyone. I am going to do my best to explain this. I currently have two separate workbooks. The first is charge sheet, which we enter the quantity used of various products; the second is an inventory tracking which tracks the number of items we currently have. What I am trying to do is "link" the two work books. So when we enter a numerical value in the charge sheet workbook it will automatically deduct from the inventory workbook. It seems rather easy but we do not save the charge sheet workbook, the number of items used is only thing entered and then printed but never saved. Can this be done and if so how?

Thanks for you help
Chris

 

[Smitty]

Welcome to the Board!

You could use a Sheet_Change event or some code to call from an "Update" button, but you'd need to provide some more specifics.

Try posting a shot of both sheets. You can use Colo's HTML Maker to do that; you'll find the link at the bottom of the page.

Smitty