Copy and paste list with varying length to specific columns/rows

Hi all,

I have worksheet a long list of names in column A. The length varies from report to report - but i have defined Lastrow in my code.

I have another workbook with a template that my macro opens and fills out certain information. (i cant post because of protected health information).

In my template from A15 to A42 is where i put the names. How can i get the vba to look at the length of my names list, and copy the first 28 to column A15, the next 28 names to column C15-c42, the next 28 to E15-42 and so on until there are no more names?

Thanks for your help!

This will do what you need.

Please Login or Register  to view this content.

Thank you! That was exactly what I needed