+ Reply to Thread
Results 1 to 6 of 6

Separate Line items

  1. #1
    Registered User
    Join Date
    11-14-2011
    Location
    Missouri, USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Separate Line items

    Hey All,

    Struggling with an issue that I am sure can be remedied by a simple(ish) macro.

    We are creating a spreadsheet that will load a list of orders into another piece of software, it is currently structured in this fashion:

    Order Qty Due Date
    1 3 12/5
    2 2 12/9

    Would like to breakdown orders with multiple quantities and make them their own seperate line item (qty 1) with its own unique order number if possible.

    Order 1 in the above example would be something like

    Order Qty Due Date
    1-1 1 12/5
    1-2 1 12/5
    1-3 1 12/5

    This would hopefully go down the list and rewrite the itemized orders in another part of the spreadsheet. I don't even know what function to use to get this started so any guidance would be aprreciated.

    Thanks,

    seif

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: Separate Line items

    Hi,

    Try this:

    Please Login or Register  to view this content.

    Dom
    Last edited by Domski; 11-14-2011 at 11:35 AM.
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,126

    Re: Separate Line items

    Please Login or Register  to view this content.
    Assumes existing data in A1:C2 output starts in E1
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    11-14-2011
    Location
    Missouri, USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Separate Line items

    Thanks guys, both codes are working as advertised. If not too much to ask, I also have data in columns D and E, which will carry forward just as the "Due Date" column. Could the code be altered to accomodate this?

    Thanks again,

    Seif

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,126

    Re: Separate Line items

    For my code just alter where the information is coming to be outputted.
    This puts it out next to existing data with a 1 column gap.

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    11-14-2011
    Location
    Missouri, USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Separate Line items

    works great, thanks again to both of you

+ 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