| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
Making report in WORD file by using information from Excel
I have got a huge database of around 100 countries in an excel file. I
created a Pivot table to get the related data pertaining to a particular country. Now, need to prepare each country's report in WORD file separately (100 WORD files) wherein text contents, format, layout of the WORD report for all the countries remains the same however the data presented in tabular form in the required section need to be extracted from the Excel. I am sick of doing copy/paste so many times from Excel to word. Is there any solution to automate the process? Also, is there any Add ins availble anywhere? If it require use of Macro by any chance it will be difficult for me as I don't know about codings in VB. Any suggestion/help will be appreciated as it will really save lot of my time. Regards, -- Shweta Srivastava |
|
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
|
Making report in WORD file by using information from Excel
See the following page of fellow MVP Graham Mayors website:
http://www.gmayor.com/ManyToOne.htm -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis. "Shweta Srivastava" wrote in message ... I have got a huge database of around 100 countries in an excel file. I created a Pivot table to get the related data pertaining to a particular country. Now, need to prepare each country's report in WORD file separately (100 WORD files) wherein text contents, format, layout of the WORD report for all the countries remains the same however the data presented in tabular form in the required section need to be extracted from the Excel. I am sick of doing copy/paste so many times from Excel to word. Is there any solution to automate the process? Also, is there any Add ins availble anywhere? If it require use of Macro by any chance it will be difficult for me as I don't know about codings in VB. Any suggestion/help will be appreciated as it will really save lot of my time. Regards, -- Shweta Srivastava |
|
#3
Posted to microsoft.public.word.newusers
|
|||
|
|||
|
Making report in WORD file by using information from Excel
Hi Shweta Srivastava,
If you use Edit|Paste Special and choose the 'Paste Link' option, Word will insert the data with a link to the pivot table. From then on, you'll only need to change the pivot table the link points to for each country's data. If there is a separate file for each country, an added advantage is that, next time you need to produce the report, all you'll need to do is to update the pivot tables and refresh the links in Word - no more copying & pasting. If you're only using one Word file, a Word macro could be used to update the link & print the report for each country in turn. -- Cheers macropod [Microsoft MVP - Word] "Shweta Srivastava" wrote in message ... I have got a huge database of around 100 countries in an excel file. I created a Pivot table to get the related data pertaining to a particular country. Now, need to prepare each country's report in WORD file separately (100 WORD files) wherein text contents, format, layout of the WORD report for all the countries remains the same however the data presented in tabular form in the required section need to be extracted from the Excel. I am sick of doing copy/paste so many times from Excel to word. Is there any solution to automate the process? Also, is there any Add ins availble anywhere? If it require use of Macro by any chance it will be difficult for me as I don't know about codings in VB. Any suggestion/help will be appreciated as it will really save lot of my time. Regards, -- Shweta Srivastava |
|
#4
Posted to microsoft.public.word.newusers
|
|||
|
|||
|
Making report in WORD file by using information from Excel
Hello Mr. Dough,
Thanks for sharing this link. I think this can suffice my need however while following manytoone addin step am getting an error as "5941 The requested member of the collection does not exist". Not able to find where am I going wrong. Please help. Regards, -- Shweta Srivastava "Doug Robbins - Word MVP" wrote: See the following page of fellow MVP Graham Mayors website: http://www.gmayor.com/ManyToOne.htm -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis. "Shweta Srivastava" wrote in message ... I have got a huge database of around 100 countries in an excel file. I created a Pivot table to get the related data pertaining to a particular country. Now, need to prepare each country's report in WORD file separately (100 WORD files) wherein text contents, format, layout of the WORD report for all the countries remains the same however the data presented in tabular form in the required section need to be extracted from the Excel. I am sick of doing copy/paste so many times from Excel to word. Is there any solution to automate the process? Also, is there any Add ins availble anywhere? If it require use of Macro by any chance it will be difficult for me as I don't know about codings in VB. Any suggestion/help will be appreciated as it will really save lot of my time. Regards, -- Shweta Srivastava . |
|
#5
Posted to microsoft.public.word.newusers
|
|||
|
|||
|
Making report in WORD file by using information from Excel
Hi Shweta Srivastava,
You may find it easier to use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://lounge.windowssecrets.com/ind...owtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. -- Cheers macropod [Microsoft MVP - Word] "Shweta Srivastava" wrote in message ... Hello Mr. Dough, Thanks for sharing this link. I think this can suffice my need however while following manytoone addin step am getting an error as "5941 The requested member of the collection does not exist". Not able to find where am I going wrong. Please help. Regards, -- Shweta Srivastava "Doug Robbins - Word MVP" wrote: See the following page of fellow MVP Graham Mayors website: http://www.gmayor.com/ManyToOne.htm -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis. "Shweta Srivastava" wrote in message ... I have got a huge database of around 100 countries in an excel file. I created a Pivot table to get the related data pertaining to a particular country. Now, need to prepare each country's report in WORD file separately (100 WORD files) wherein text contents, format, layout of the WORD report for all the countries remains the same however the data presented in tabular form in the required section need to be extracted from the Excel. I am sick of doing copy/paste so many times from Excel to word. Is there any solution to automate the process? Also, is there any Add ins availble anywhere? If it require use of Macro by any chance it will be difficult for me as I don't know about codings in VB. Any suggestion/help will be appreciated as it will really save lot of my time. Regards, -- Shweta Srivastava . |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making tabs in Word like you do in Excel | Page Layout | |||
| page number in word, with enbedded excel sheets -audit report | Microsoft Word Help | |||
| Making templates in Word with use of storing of information. | Microsoft Word Help | |||
| convert a report from word to excel | New Users | |||
| How do I create a report in Word from data in Excel, I need to au. | New Users | |||
Linear Mode
