Running Total for tracking Inventory

CJBaird

New Member
Joined
Dec 21, 2005
Messages
1
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
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
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
 

Watch MrExcel Video

Forum statistics

Threads
1,119,002
Messages
5,575,501
Members
412,670
Latest member
Khin Zaw Htwe
Top