Column continuity and page break prob; now taking epic proportions :-)

Hello everyone,

I am trying to create a multi-paged inventory checklist of DVD titles. The sheet is mostly text based, created in Excel 97. The eventual goal is to use this checklist as a template to catalog all other types of media too (CDs, video game carts,...).

The spreadsheet is 4 Columns across (A to D) and each page in the spreadsheet is 30 rows in length. Columns 'A' and 'C' will have check-boxes; Columns 'B' and 'D' are the DVD Titles (text). I have set the page break to be every 30 rows (row 31, 61, 91, 121, etc.... )

The problem I am having is trying to find a way to get Excel to automatically continue text data to the next text column on the same worksheet page. When both text columns are filled, I would like Excel to automatically move to the next text column, on following page.

To be a bit more clear--- When I have filled all the 30 rows in column 'B', for Excel to automatically continue the list in column 'D'. When all 30 rows of column 'D' (page 1) are filled, I would like Excel to automatically continue the list on the next page, starting back in column 'B'. Hope that makes sense?

By default, Excel just keeps the list going in one column, making new pages every 30 rows. That makes for a very long list, especially when it comes to printing!

I am sure there is probably a very easy solution, but for the life of me, I'm stumped. I have been searching posts all weekend with no luck.

I would grateful for any kind help from forum members. I am still an extreme noob when it comes to any formulas or VBA coding.

Cheers and thanks in advance,

Shayne T.