I'm trying to keep a running inventory of booze!
We record what is brought up every night and what we bring back down
Then excel calculates how much we've used.
I want to transfer it to a seperate page and subtract it from inventor
for the running inventory but I need it to zero out the used collu
without erasing the inventory or the running inventory so on the nex
night I can do the same. Then I need to be able to add to the inventor
when we recive orders.

ANY HELP!!!!!!!!!!!!!

--
Message posted from http://www.ExcelForum.com

Maintain a list of what you receive and what you sell.

Then use sumif on each list to get the current balance.

=sumif(items,item,qty_receipts) - sumif(items,item_qty,qty_sales)

--
Regards
Tom Ogilvy


"doran313 " wrote in message
...
I'm trying to keep a running inventory of booze!
We record what is brought up every night and what we bring back down.
Then excel calculates how much we've used.
I want to transfer it to a seperate page and subtract it from inventory
for the running inventory but I need it to zero out the used collum
without erasing the inventory or the running inventory so on the next
night I can do the same. Then I need to be able to add to the inventory
when we recive orders.

ANY HELP!!!!!!!!!!!!!!


---
Message posted from http://www.ExcelForum.com/