Is there a way to populate a list of data from excel to word?

[Phil J W]

Hi,

I have a list of data which can range from 1-500 numbers (vertical) and i'm
wondering if theres a way or a macro that will allow me to convert that list
to a word file but instead of it being veritcal it converts it to a
horizontal list, with the data in cells left to right?

Thanks

 

[macropod]

Hi Phil,

You could use a Copy & Edit|Paste Special|Transpose operation in Excel, then copy & paste the transposed data to Word.

However, even with the widest practical page width, I doubt you could get 500 records on a single line in Word. What exactly are you
trying to achieve?

 

[JoAnn Paules]

Do it in Excel first.

Copy, (click in another cell), Paste Special - Transpose

 

[Phil J W]

sorry i wasnt more clear, it doesnt have to be on one line, it can be 5 cells
or even 2 accross...

Do it in Excel first.

Copy, (click in another cell), Paste Special - Transpose

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

Hi,

I have a list of data which can range from 1-500 numbers (vertical) and
i'm
wondering if theres a way or a macro that will allow me to convert that
list
to a word file but instead of it being veritcal it converts it to a
horizontal list, with the data in cells left to right?

Thanks

 

[Phil J W]

Sorry again, i dont know if i was clear again on my last post. if i have 20
feilds of data, id like it to go from one long list, to 4 cells across 5 rows
down.

sorry i wasnt more clear, it doesnt have to be on one line, it can be 5 cells
or even 2 accross...

Do it in Excel first.

Copy, (click in another cell), Paste Special - Transpose

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

Hi,

I have a list of data which can range from 1-500 numbers (vertical) and
i'm
wondering if theres a way or a macro that will allow me to convert that
list
to a word file but instead of it being veritcal it converts it to a
horizontal list, with the data in cells left to right?

Thanks

 

[JoAnn Paules]

Doesn't matter, I'd still suggest transposing it in Excel first.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

sorry i wasnt more clear, it doesnt have to be on one line, it can be 5
cells
or even 2 accross...

Do it in Excel first.

Copy, (click in another cell), Paste Special - Transpose

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

Hi,

I have a list of data which can range from 1-500 numbers (vertical) and
i'm
wondering if theres a way or a macro that will allow me to convert that
list
to a word file but instead of it being veritcal it converts it to a
horizontal list, with the data in cells left to right?

Thanks

 

[Phil J W]

is there a way to transposing it to mulitple lines instead of 1 looong line?

Thanks again for your help.

Doesn't matter, I'd still suggest transposing it in Excel first.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

sorry i wasnt more clear, it doesnt have to be on one line, it can be 5
cells
or even 2 accross...

Do it in Excel first.

Copy, (click in another cell), Paste Special - Transpose

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"


Hi,

I have a list of data which can range from 1-500 numbers (vertical) and
i'm
wondering if theres a way or a macro that will allow me to convert that
list
to a word file but instead of it being veritcal it converts it to a
horizontal list, with the data in cells left to right?

Thanks

 

[Phil J W]

wow im an idiot. I copy the data, past it into word as unformated text and
then covert the unformated text into a table........sorry its monday. Thanks
for the help guys.

is there a way to transposing it to mulitple lines instead of 1 looong line?

Thanks again for your help.

Doesn't matter, I'd still suggest transposing it in Excel first.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

sorry i wasnt more clear, it doesnt have to be on one line, it can be 5
cells
or even 2 accross...

:

Do it in Excel first.

Copy, (click in another cell), Paste Special - Transpose

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"


Hi,

I have a list of data which can range from 1-500 numbers (vertical) and
i'm
wondering if theres a way or a macro that will allow me to convert that
list
to a word file but instead of it being veritcal it converts it to a
horizontal list, with the data in cells left to right?

Thanks

 

[JoAnn Paules]

Ding - ding - ding! All that matters is that you got what you needed.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

wow im an idiot. I copy the data, past it into word as unformated text and
then covert the unformated text into a table........sorry its monday.
Thanks
for the help guys.

is there a way to transposing it to mulitple lines instead of 1 looong
line?

Thanks again for your help.

Doesn't matter, I'd still suggest transposing it in Excel first.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"


sorry i wasnt more clear, it doesnt have to be on one line, it can be
5
cells
or even 2 accross...

:

Do it in Excel first.

Copy, (click in another cell), Paste Special - Transpose

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"


Hi,

I have a list of data which can range from 1-500 numbers
(vertical) and
i'm
wondering if theres a way or a macro that will allow me to convert
that
list
to a word file but instead of it being veritcal it converts it to
a
horizontal list, with the data in cells left to right?

Thanks

 

[macropod]

Hi Phil,

If you need to do this on a regular basis, there's a simple formula you can use in Excel (based on the OFFSET function) to turn a
column (or row) of data into a multi-column table.

--
Cheers
macropod
[MVP - Microsoft Word]

wow im an idiot. I copy the data, past it into word as unformated text and
then covert the unformated text into a table........sorry its monday. Thanks
for the help guys.

is there a way to transposing it to mulitple lines instead of 1 looong line?

Thanks again for your help.

Doesn't matter, I'd still suggest transposing it in Excel first.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"


sorry i wasnt more clear, it doesnt have to be on one line, it can be 5
cells
or even 2 accross...

:

Do it in Excel first.

Copy, (click in another cell), Paste Special - Transpose

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"


Hi,

I have a list of data which can range from 1-500 numbers (vertical) and
i'm
wondering if theres a way or a macro that will allow me to convert that
list
to a word file but instead of it being veritcal it converts it to a
horizontal list, with the data in cells left to right?

Thanks