I am trying to keep a product inventory for the supplies our crew use on jobs. I can't find/think of a formula to do this, so was wondering if anyone could help. Input information would consist of : date, product, amount of pruduct and job name. At the end of each month i would like to be able to track what product and the amount of product used on each job. THANKS!!
there are a lot of
inventory templates for Excel available through Microsoft and others. Have you tried googling excel inventory templates?
there are already a number of small database programs that do this
for a cheap price and some for free too. Google for them.