Not sure how to use this... I don't do much of this thing. I'll answer your
questions here and I hope you can understand.
The Ph#, lastnames, firstnames and addresses are all in different columns.
I'm not sure what VBA macro is, or how to use it.


"Gord Dibben" wrote:

Are your ph nos, lastnames, firstnames, addresses in 1 column or?

I would suggest entering the info on one sheet, sort after entering/deleting
data.

When you are ready to print, copy to another sheet for printing in snaked
columns using VBA macro.

Post back with more detail.

BUT.............I doubt if Excel will do a better job than Word when it
comes to formatting a printout.


Gord Dibben MS Excel MVP

On Thu, 11 Sep 2008 11:35:01 -0700, Notbobathome
wrote:

I have a unique problem. I'm using office 2007 ( I also have access to 2003
). I'm trying to format a list of names from Word to Excel. I don't mind
pounding in the data, but I still want it to act like it does in Word. I
have a list of phone numbers, Last names, first names & Addresses. I want to
be able to print them out onto a page of 81/2X11 paper. My problem is this.
I want to have 2 columns on each paper, I also want to be able to add
additional names & information as well as remove them when they leave,
meanwhile keeping them in alphabetical order with the columns interacting
with each other... I hope I made this clear. Does this sound like something
that excel can do ??? I want to get away from Word because the formatting is
poor... the edges of each row don't quite line up and the print-out looks
amateur-istic. If you want, reply to ....
Thanks for any help anyone can render