Attached is a workbook that has two tabs: Tab "Template" allows users to enter order information for shirts/blouses. They can enter as many as they need by copying/pasting a section.
Highlighted in bright yellow are the styles, descriptions, colors and sizes.
On the "Output" tab I need to list each style, its description, its color and each size. The catch: each size needs to be on a different row.
Since the number of style and the number of sizes can change within each section, I'm unsure how to do this. I think VBA is the way to go but have no idea how to begin. Any help would be so appreciated!