how do I do this

[jblair626]

I need a to keep an accurate count of my inventory. I built a detailed excel program, But it only works when I fill in every column. For instance. Column 1 is Amount sold, which is done every date, column 2 and 3 is Loose and Cooler, which is a physical count. Column 4 is Supplied, which is done everytime we get a shipment. Column 5 and 6 are Jeff and Shift, which are free beers given to the owner Jeff and to the bartenders after their shift.
I need to keep an accurate count of the inventory, but when a physical count is done the inventory needs to be updated, as well as calculate the difference, such as broken or stolen items. I need history of inventory as well as a history of the difference for each product and a daily difference.

Can anyone help me, Here is my excel file for better understanding.
https://skydrive.live.com/?id=2ED3E...d=2ED3E5547B0EECF6&resid=2ED3E5547B0EECF6!162

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=614323

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).