getting cells to shift to next column

[Guest]

Hello-

I am trying to do an excel spreadsheet where I am typing in book titles and
authors. I have it set up where I have 25 titles and authors, in three
"columns" per page, then it would print out to the next page. Ex:

title : author title : author title : author
title : author title : author title : author
title : author title : author title : author, etc

(next page)
title : author title : author title : author, etc.

If I need to insert a new title and author in alphabetical order, I am
wanting the bottome title and author to shirt up to the next column, and the
last title and author combination of the third column of the page to shift to
the firt column of the second page. How would I do this?

Hope this makes sense! thanks

 

[Otto Moehrbach]

You're not the only one who is confused. If I follow what you are doing,
you are doing a lot of work. I suggest you let Excel do the work. You paid
for it. Get your money's worth!
This is just a suggestion, mind you, but it might make your life easier.
Why not type in all the titles and authors in 2 columns, Columns A & B. All
of them. Excel has 65,536 rows so that should hold all of them. If you
want to insert a new title/author in alphabetical order, just type it at the
bottom and sort the whole thing. These 2 columns would always stay there
and you would do all of your editing in those 2 columns.
Now, if you want to print or just display the whole list in 3 double
columns like you say you now have, you can tell Excel to "snake" the
columns. Excel will then list them as you have them. Columns A & B will
stay as you typed them, for future editing.
If you want to print these snaked columns and you want just yea many
rows per page, you can tell Excel to insert page breaks every so many rows
and Excel will do that, then print it all out. If all this sounds like
something you think you want, post back and I'll help you with it. HTH
Otto

 

[Guest]

This sounds like exactly what I would like to do! Thanks! How do you "snake"
the columns when printing?

 

[Otto Moehrbach]

Snaking the columns is done by VBA (automation built into Excel). I
envision that you would have a sheet with 2 columns filled down. At the top
of the sheet would be 3 buttons, one for Sorting, one for Display, and one
for Printing.
The Sort button will cause the 2 columns to be sorted by one of the
columns. The Display button would snake the columns and show it to you.
The Print button would snake the columns and print the result.
If this were for me, I would have a second sheet with the headers like I
want them. When you clicked on the appropriate button for Display or Print,
Excel would snake the columns to that second sheet and display/print the
sheet. How does that sound?
If you wish, send me your file or a sample of your file. I just need
the layout of what you have and what you want (the second sheet?), so if you
feel your data is proprietary, just fake the titles and authors. Do include
a sample of what you want the second (display and print) sheet to look like.
For instance, do you want a narrow blank column between the double columns
in the second sheet to set the data apart?
If you are VBA capable I'll just send you the code for the snaking part.
Let me know. My email address is (e-mail address removed). Remove the "nop"
from this address. Otto