Hey Guys
I have a excel worksheet I am trying to create. I have done some research to try and figure out if this is possible or not but have not come up with much. I have a simple chart made that has a Total of a certain Item, a number taken of that item, and a current total that subtracts the two.
I want to know if it is possible to have the chart update after I take a item. For example, if I take 5 cans of air, my current stock left will show as 18. Is there a way to make the "number taken" column reset to Zero and the current inventory update to 18 from 23. And this would do this each time someone uses this sheet.
I hope I am making sense I am trying to describe it as best as possible.
Thanks for your help
I am using office 2000 at my work
Bookmarks