inserting from database

[Glenn]

I'm inserting data from a database.

I want to be able to print it so that the data comes out in columns on a
page instead of in one row that prints on several pages.

For instance, I'm importing 2 fields such as:

Part # Description
1 Widget ABC
2 Widget DCG
3 Widget ILR
etc.
30 Widget MMR

I want it to print out (or even import) like this:

Part # Description Part # Description
1 Widget ABC 30 Widget MMR
2 Widget DCG
3 Widget MMR

Is there a way to do this?

Thanks in advance.

 

[Dave Peterson]

I like to copy the data into MSWord and use MSWord's builtin ability to do
column layout.

If that doesn't work for you, David McRitchie has a macro that will "snake" the
columns.
http://www.mvps.org/dmcritchie/excel/snakecol.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm