+ Reply to Thread
Results 1 to 2 of 2

distribute stock quantity over different lines so sum ends up with stock quantity

  1. #1
    Registered User
    Join Date
    02-22-2013
    Location
    saudi
    MS-Off Ver
    Excel 2003
    Posts
    35

    distribute stock quantity over different lines so sum ends up with stock quantity

    Hi experts

    I have 9 products with X prices & Y quantity, and i need you to distribute those products around 300 invoices/rows To my diffrent customers (they can be repeated) Thé final quantity and the final prices on All the invoices must match with the initial stock.

    filling the customer column , products and quantity is random on condition that stock is not exceeding the initial stock.

    wish experts here can help me

    BR
    Ibrahim
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,348

    Re: distribute stock quantity over different lines so sum ends up with stock quantity

    Dear Ibrahim,

    Such macro shall do the job for you:

    Please Login or Register  to view this content.
    I think it meets all requirements. Of course you can add more data to Data Base sheet.
    Honestly, it probably should go to https://www.excelforum.com/commercial-services/
    but as I treated it as a kind of challenge, I solved it on the open forum.
    Attached Files Attached Files
    Best Regards,

    Kaper

+ 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. VBA Loop to subtract values from stock quantity
    By sam.schardt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-21-2017, 12:00 PM
  2. VBA Loop to subtract values from stock quantity
    By sam.schardt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2017, 08:16 PM
  3. [SOLVED] Stock quantity range search
    By makinmomb in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-07-2015, 11:07 AM
  4. [SOLVED] Help with VBA to Select next available quantity of stock. (FIFO)
    By JRidge in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-24-2014, 03:26 AM
  5. [SOLVED] Stock remarks depending on quantity
    By makinmomb in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-15-2014, 02:26 AM
  6. Formula to translate stock ending quantity
    By suikt in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-19-2014, 02:53 PM
  7. How to Update Stock quantity if I sold items?
    By saad3000 in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 12-11-2007, 06:18 PM

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