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
Bookmarks