+ Reply to Thread
Results 1 to 3 of 3

Inventory and stock sheet running total calculation

  1. #1
    Registered User
    Join Date
    10-12-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2013
    Posts
    7

    Inventory and stock sheet running total calculation

    Hello friends, I have inventory xls file, I have Input, Inventory and stock sheets, I enter data in input sheet it automatically add to inventory sheet. But I want to link inventory sheet to stock sheet If purchase word is in the cell it should add to stock sheet and if sell word is in the cell it should subtract from the stock sheet. Pls help.....

  2. #2
    Forum Contributor
    Join Date
    03-27-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    154

    Re: Inventory and stock sheet running total calculation

    post a sample file with expected result

  3. #3
    Registered User
    Join Date
    10-12-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2013
    Posts
    7

    Re: Inventory and stock sheet running total calculation

    Thanks for your reply, I need to link inventory sheet to stock sheet if purchase word appear in transaction colume then add qty to stock and if sell word appear in transaction colume then minus from the stock.
    Attached Files Attached Files

+ 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 formula for inventory
    By crusher949 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-02-2013, 02:02 AM
  2. Inventory - Running Total Formula
    By rivertech233 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-14-2012, 12:30 AM
  3. Excel 2007 : Sumif - inventory/running total
    By CaliberChris in forum Excel General
    Replies: 2
    Last Post: 09-28-2011, 02:10 PM
  4. running total formula for inventory
    By trace1287 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-06-2009, 06:20 PM
  5. Keeping a running total for Liquor Inventory
    By BeverageDpt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-03-2008, 05:29 PM

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