Results 1 to 8 of 8

DV Update List Product on Sells if Stock is 0

Threaded View

  1. #1
    Registered User
    Join Date
    06-25-2022
    Location
    Madagascar
    MS-Off Ver
    2013
    Posts
    15

    DV Update List Product on Sells if Stock is 0

    Hi,

    I have a file with 2 sheets (Stock & Sells).
    On Stock sheet, i have a table with all my products and the remaining stock.
    On Sells sheet, i have a table with a column "Product" in which i want to make a data validation list based on Products available on Stocks.
    If Product on Stocks are available, i want it to appears on DV list, but if Product is sold and product on Stock is equal to 0, i want that the product doe not appears anymore on futur DV list on Sell sheet.

    Please find attached my excel file.

    Thank you for your help.

    Regards,
    Vij401
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 03-07-2022, 06:03 PM
  2. How to auto update product stock when a sale happens
    By psahani in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2018, 06:45 AM
  3. Want to update stock sheet as and when i enter product code in invoice sheet
    By anilpatni1234 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-22-2017, 01:18 AM
  4. Stock List Update Tool, I would love someone to help (do it for) me.
    By ServerCom in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-03-2015, 12:40 AM
  5. [SOLVED] Copy price to more than one product - Stock List
    By Ben1985 in forum Excel General
    Replies: 2
    Last Post: 08-11-2014, 12:42 PM
  6. Would like to update stock list from daily sales list
    By DIPPYDOR in forum Excel General
    Replies: 6
    Last Post: 05-29-2014, 10:53 AM
  7. Update Prices on price list and ID and add New Items - Multiple Product Lines
    By KNS Brakes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2011, 09:50 AM

Tags for this Thread

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