[macropod[_2_]]

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