Hi,
I have an order form that i would like to be able to split data in a row based on the quantities of certain items. Once the max is hit for that item i would need it to copy the remaining down until there is no more of that item.
Small items have a max quantity of 10
Large items have a max of 5
Sorry, if its hard to understand what i'm asking. I have attached a workbook with what is the beginning data and the end result of what ill be needing. I don't have much experience with VBA but i can learn quickly and adapt pretty easily. Any help would be greatly appreciated. Thanks.
Bookmarks