Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have an excel (or access if easier) doc that contains rows of data.
I would like to create a separate word doc from each row. The clomuns are subject,number,info I would love the title of each to be "<Number-<Subject" with the content of the doc itself made up from the Info row. Is there a way to do this - I know a bit of perl but was hoping for an easy solution....... |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try this.
Select the row Copy to the clip board Switch to MS Word Use either Paste to paste the clipboard contents as a table or Paste Special with the Link Option selected. Perhaps specify as an Excel Worksheet Object. With many rows this could get tedious but I will get you what you want. " wrote: I have an excel (or access if easier) doc that contains rows of data. I would like to create a separate word doc from each row. The clomuns are subject,number,info I would love the title of each to be "<Number-<Subject" with the content of the doc itself made up from the Info row. Is there a way to do this - I know a bit of perl but was hoping for an easy solution....... |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Uh, I was hoping for something a wee bit automated.
|
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have an excel (or access if easier) doc that contains rows of data.
I would like to create a separate word doc from each row. ... One approach is Word's "Mail Merge" feature. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
changing word files to excel files | Excel Discussion (Misc queries) | |||
How do you export MathType from Word into Excel and be able to so. | Excel Worksheet Functions | |||
Can Excel Export Data to Word Format? | Excel Discussion (Misc queries) | |||
Illegal operation error while printing EXCEL or WORD Files | Excel Discussion (Misc queries) | |||
How to I create a pdf file from Word or Excel files | Excel Discussion (Misc queries) |