vertical transposition macro

look at your never ceasing to amaze! it's working except it's not auto filling column I after the transposition, but it's doing it for F and G. I was trying to find that part in the code to tell it myself but i'm not seeing it. Sorry to be so daft.

also, i just ran it, and i think my example wasn't clear, it was for one style as a test, but in reality, the sheet i'll be working with will have hundreds of styles so the macro will need to read the whole worksheet. i'm attached a more flushed out example for your ref. you'll notice the columns are a little different, i revised the code to work with this report... which will be the report format used from now on.

Please Login or Register  to view this content.

figured this part out: look at your never ceasing to amaze! it's working except it's not auto filling column I after the transposition, but it's doing it for F and G. I was trying to find that part in the code to tell it myself but i'm not seeing it. Sorry to be so daft.

So, i just need the code to loop through the whole worksheet.

never mind, solved, it stops when it sees blanks, i get it now, thanks so much for your help!