+ Reply to Thread
Results 1 to 6 of 6

Stock Update

  1. #1
    Registered User
    Join Date
    03-21-2017
    Location
    Colombo
    MS-Off Ver
    2010
    Posts
    16

    Stock Update

    HI Respected members ,
    I am looking for your support to find a solution for my simple inventory system.
    I have my data base in a sheet named stock where I have my stock listed with the stock code with the current stock
    stock.JPG

    I do the selling with simple page to record with vlookup function using the Item code from the stock table ..
    As I do the sales, I need to reduce the actual stock on the stock sheet ..

    sales 2.JPG
    Is this possible ?
    (I use a barcode reader to read my item codes .)
    *Hope you guys can help me ---

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Stock Update

    Hi and welcome to the forum

    Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    03-21-2017
    Location
    Colombo
    MS-Off Ver
    2010
    Posts
    16

    Lightbulb Re: Stock Update

    MY BAD,

    i WILL MAKE IT SO EASY.....

    I HAVE 10 APPLES FOR SALE IN STOCK PAGE

    I SELL 2 APPLES IN SALES PAGE

    SO MY CURRENT STOCK SHOULD BE UPDATED AS 8 IN STOCK PAGE
    Attached Images Attached Images
    Attached Files Attached Files

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Stock Update

    In D5
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  5. #5
    Registered User
    Join Date
    03-21-2017
    Location
    Colombo
    MS-Off Ver
    2010
    Posts
    16

    Re: Stock Update

    It is not working ! The stock table should be updated as soon as we make a sale,,

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Stock Update

    In D5 is where the upload says it should return 8.

    Please see attached.
    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. Have stock chart update stock and clear itself
    By Normonious in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-01-2017, 11:49 AM
  2. [SOLVED] Stock Update
    By Rob Reed in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  3. [SOLVED] Stock Update
    By Rob Reed in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 AM
  4. [SOLVED] Stock Update
    By Rob Reed in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  5. [SOLVED] Stock Update
    By Rob Reed in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  6. Stock Update
    By Rob Reed in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. [SOLVED] Stock Update
    By Rob Reed in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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