+ Reply to Thread
Results 1 to 3 of 3

Keeping a running total for Liquor Inventory

  1. #1
    Registered User
    Join Date
    10-02-2008
    Location
    HS
    Posts
    3

    Keeping a running total for Liquor Inventory

    Ok, so here is the problem.

    I need to keep track of how much liquor I have in my store room. Liquor gets issued to the bar, banquets and the pool. In those columns I need those numbers to subtract to the current inventory total and blank out when I open up the workbook again. In the Inventory IN column I need that number to add to the current inventory total and blank out when i open it up again so i always have a current on hand number of the amount of liquor i have in the store room....soooo frusterating im close to getting it....im in the view code portion trying to write the correct code....please help! :-)

    Cheers!

    Attached is the form i made....
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor mdbct's Avatar
    Join Date
    11-11-2005
    Location
    CT
    MS-Off Ver
    2003 & 2007
    Posts
    848
    I would change your sheet in a couple ways. One - have the inventory column actively change as you change/issue the bottles to specific places. Two have a column that has the ending inventory / opening inventory value stored.

    The following code fires when the workbook is closed - it goes in the Workbook module. It updates the opening inventory to the closing inventory. (I put it in column Q). It then clears our each of the locations daily issuance and incoming inventory.

    Please Login or Register  to view this content.
    My version is attached.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-02-2008
    Location
    HS
    Posts
    3
    Thank you thank you thank you! Thats exactly what i was looking for...your suggestion works better too!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Running Total???
    By valdostaflying in forum Excel General
    Replies: 2
    Last Post: 06-19-2012, 11:18 AM
  2. running total formula for inventory
    By trace1287 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-06-2009, 06:20 PM
  3. Keeping a running total in a cell
    By hri1428 in forum Excel General
    Replies: 1
    Last Post: 09-18-2008, 01:48 PM
  4. Replies: 16
    Last Post: 03-27-2007, 02:14 AM
  5. Running Total? Any help?
    By browncj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2006, 09:11 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1