Create book pages, on one sheet from list

[Barbara]

I have a list, (17720 rows, may grow in future) that is formated and ready to
go. Columns are set up from A to N with row 1 (column headings) to be
repeated on all pages. Data is actually in col B thru E at this time. A, F G
H and N are just space set columns. I want to have 61 rows of data per page.

So what I did was cut and paste B63 : E123 to I2 : L62. This gave me my
first page.

Then I deleted the empty rows it left (B63 : E123) and the list moved up.

Then I repeated this process all the way to Row 18000. (In case I start with
more rows of data in the future).


I thought I had the marco done (took me way over an hour), but then I
realized it wasnt correct, somewhere I missed a row and the numbers were not
numerical anymore.

I tried a second time to do this and somehow I ended up with a good book
(saved as a pdf) but there is an error in the macro when I tried to test it.


An easier way whould have been to create new sheets, but the format wouldnt
go with it and I would have had to format about 147 sheets.

There has to be an easier way to do this.

Any help is apprecated.

Thanks,
Barbara

 

[Pete_UK]

David McRitchie has many tips here:

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

on "snaking" columns in the way you describe.

Hope this helps.

Pete

 

[Barbara]

I have used one of these macros before and it worked ok for it. But this is a
little more intense and alot of Davids ideals are foreign to me.
Thanks for your time.

 

[Pete_UK]

Barbara,

If you post the macro you have recorded here, and point out where it
went wrong, I'm sure someone will be able to advise you further.

In recording the macro, you will not have been able to incorporate
looping structures, but these can simplify and shorten your macro
considerably.

Pete