+ Reply to Thread
Results 1 to 4 of 4

Break customer orders based on quantity

  1. #1
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Davenport, Iowa
    MS-Off Ver
    Excel 365
    Posts
    206

    Break customer orders based on quantity

    Hi,

    I have a spreadsheet with a list of customer items they wish to purchase and the quantity of each item and their respective due dates. I am looking to see if a macro can look at the quantity and split each item out into individual line items with a quantity of 1.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Break customer orders based on quantity

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Break customer orders based on quantity

    Here you go. It's a matter of managing two loops.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  4. #4
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Break customer orders based on quantity

    Or
    Please Login or Register  to view this content.

+ 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. [SOLVED] Split orders based on quantity and indicator
    By sriley5 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-14-2019, 11:12 PM
  2. Google Sheets - line up orders by turnover or quantity
    By Ymmies in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 01-18-2019, 08:28 AM
  3. Calculate time difference between two orders per customer
    By bobbielin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-13-2013, 02:36 PM
  4. Replies: 0
    Last Post: 10-25-2012, 09:52 AM
  5. Replies: 11
    Last Post: 10-25-2012, 12:26 AM
  6. Help with sorting customer orders and outputting them to a new sheet
    By JBrez in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 06-17-2012, 07:21 PM
  7. [SOLVED] tracking customer orders for ad specialty distributror
    By Abie Ross in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 09-23-2005, 01: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