Word to Excell2000 macro help

[dfkelly42]

In a nutshell I have pasted a address book from a Word Doc
example

Bob Smith
1234 turkey Ave
Putsville, UT
12345
(999)999-9999

Bill Smith
1235 Hen peck road
butte, Mt
65432
(999) 555-5555

etc......
The macro will cut and paste in different cells on the same row bu
repeats itself to the original row when I proceede down the page.
I built a macro but it is tied to the original cell number.
How do I lose the cell number distinction so I can work my way down th
document. I have 300 of these....
PLEASE HELP,
Do

 

[AlfD]

Hi!

Could you post the macro, please?

Al

 

[Debra Dalgleish]

If your address list has a consistent number of rows for each address,
you can use the instructions in the following MSKB article:

Converting Multiple Rows/Columns to Columns/Rows
http://support.microsoft.com/default.aspx?id=116289