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).


---
Message posted from http://www.ExcelForum.com/

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.



"shawb <" wrote:

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).

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson