1 column sheet to multi column page breaked - how to?

[dougp]

I have a single column, 20,000 row worksheet. The single column contains product number (product number order) and price. I have to print a price book. To reduce the number of pages I want to create a multi column version.

It should read down the first column for first 60 products, then go to the top of the next column and read down the next 60 products and so on for a total of 8 columns.
Then it would page break and move to the next page to repeat the process and continue to do so until the entire file is converted.

Any suggestions? Thanks Doug

 

[Mark W.]

Take a look at ASAP Utilities freeware addin at www.asap-utilities.com it has a "paper saver" feature like you're describing.