C
chuck2
Good afternoon all.
I need a little assistance with using spreadsheets to keep an
inventory updated. I have 7 column headings each referring to a
different type of equipment. I have another column for a date, one
representing whether the the equipment was shipped or received and
finally which facility was receiving or shipping the product.
So in each row I would enter a date, how many pieces of equipment was
either shipped or received and then the shipping / receiving facility.
My questions are, how would I keep a running total of a particular
facilities current inventory with so many shipments and deliveries?
Secondly, would it be easier to make a different worksheet for each
facility? And keep track that way?
This is the first time using this forum so any help would be greatly
appreciated.
I need a little assistance with using spreadsheets to keep an
inventory updated. I have 7 column headings each referring to a
different type of equipment. I have another column for a date, one
representing whether the the equipment was shipped or received and
finally which facility was receiving or shipping the product.
So in each row I would enter a date, how many pieces of equipment was
either shipped or received and then the shipping / receiving facility.
My questions are, how would I keep a running total of a particular
facilities current inventory with so many shipments and deliveries?
Secondly, would it be easier to make a different worksheet for each
facility? And keep track that way?
This is the first time using this forum so any help would be greatly
appreciated.