print half of rows on left and other half on right

[Guest]

I've got 816 rows in thin columns. I want to print down to 408 rows and then
have Row 409 appear at the top of the first page.

That is, if it takes 4 pages, Page 1 is data row 1 down to 100 on the left
and 409 thru 500 on the right side of page 1.

Also, when I add rows later, the info on noth sides of the page adjust.

Does anybody understand me???

 

[Stephen]

I've got 816 rows in thin columns. I want to print down to 408 rows and
then
have Row 409 appear at the top of the first page.

That is, if it takes 4 pages, Page 1 is data row 1 down to 100 on the left
and 409 thru 500 on the right side of page 1.

Also, when I add rows later, the info on noth sides of the page adjust.

Does anybody understand me???

Have a look here:
http://www.mvps.org/dmcritchie/excel/snakecol.htm

 

[Pete_UK]

David McRitchie has a routine and some comments on how to "snake"
columns here:

http://www.mvps.org/dmcritchie/excel/snakecol.htm

Hope this helps.

Pete