Running totals in excel
 

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.


--
chuck2
------------------------------------------------------------------------
chuck2's Profile: http://www.excelforum.com/member.php...o&userid=29642
View this thread: http://www.excelforum.com/showthread...hreadid=493546

Running totals in excel
 

This is not the type of problem Excel is very well suited for.
But it can be done; check:

http://www.mcgimpsey.com/excel/accumulator.html

--
Kind regards,

Niek Otten

"chuck2" wrote in
message ...

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.


--
chuck2
------------------------------------------------------------------------
chuck2's Profile:
http://www.excelforum.com/member.php...o&userid=29642
View this thread: http://www.excelforum.com/showthread...hreadid=493546