column formatting

[glazejs]

I need to print a list of approx 10,000 attendees of an event. Want to print 2 columns per page.

The list is currently all in column A and B (first name, last name). Rows are 1 - 10,000

I want to format automatically so all the names from page 2, go to columns D-F on Page 1. And then the data from Page 3 moves up to replace what was on Page 2. (I understand that I can, after the reformatting, sort by Column B, and delete all the blank pages at the bottom).

Etc.

So instead of having 200 pages of Column A and B, I have 100 pages of Columns A/B and D/F

Thnx

 

[Gerald Higgins]

Looks like a duplicate thread
http://www.mrexcel.com/forum/showthread.php?t=547679

 

[Joe4]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).