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

dougp · Mar 20th, 2002, 09:31 AM

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. · Mar 20th, 2002, 11:49 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 09:31 AM	#1
dougp New Member Join Date: Mar 2002 Location: Doug Potter Posts: 3	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

Mar 20th, 2002, 11:49 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Take a look at ASAP Utilities freeware addin at www.asap-utilities.com it has a "paper saver" feature like you're describing.