Macro for Copying, Transposing Dynamic Non-Continuous Rows

  • Hello -

    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!

    Thank you!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!