Selecting in groups within a sort

[shawb]

OK so I have an autofilter array like so

Adam A
Brad A
Charlie B
Sandra A

Anyway what I do in my macro is select all the A's from the autosort.

What I want to do is paste all the names with A's next to them into a
report on another worksheet. This report can only fit twelve peoples
names to a page. How do I select the first 12 names, then the second
twelve names etc. (given that they must be A's).

 

[Dave Peterson]

Maybe you could paste all the names of the people with A's in a temporary
worksheet.

Then loop through that list 12 at a time.