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
Thanks for you help
Chris