+ Reply to Thread
Results 1 to 5 of 5

Stock inventory, subtract purchased stock from current stock and continue with second row

  1. #1
    Registered User
    Join Date
    11-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    4

    Stock inventory, subtract purchased stock from current stock and continue with second row

    sir , i am trying to make a inventory, in this i have 2 sheets one is transaction and other is inventory, in inventory i have a column name purchased stock and stock after transaction. where it should be updated after any transcation. in transaction sheet if you see there is same two columns which should be updated after transcation how to do it.
    Attached Files Attached Files

  2. #2
    Forum Contributor visha_1984's Avatar
    Join Date
    11-27-2012
    Location
    Pune,India
    MS-Off Ver
    Excel 2010
    Posts
    290

    Re: Stock inventory, subtract purchased stock from current stock and continue with second

    Hi, MURUGANRAJ

    pls refer my attachment.
    Happy to Help

    VISHA

    Click *, if the suggestion helps you!
    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>> "Mark your thread as Solved"

  3. #3
    Registered User
    Join Date
    11-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Stock inventory, subtract purchased stock from current stock and continue with second

    thanks visha for your help, but my need is daily there will be transaction for the same product, so when i type 1001 it should see what is the current stock minus purchased stock for the next transaction. is it possible

  4. #4
    Registered User
    Join Date
    11-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Stock inventory, subtract purchased stock from current stock and continue with second

    hi visha , can you help on this issue, i will again upload {stock test} file.
    Attached Files Attached Files
    Last edited by MURUGANRAJ; 01-29-2013 at 01:57 AM.

  5. #5
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Need help on how to calculate stock after transaction

    Hi Muruganraj,

    Try using below formula;-
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    See attached:- Attachment 210325

    Regards,
    DILIPandey
    <click on below * if this helps>
    Attached Files Attached Files
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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