Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have got a huge database of around 100 countries in an excel file. I
created a Pivot table to get the data pertaining to a particular country. Now, need to prepare final report in WORD file for each country seperately (100 WORD files) wherein text contents for all the countries remains the same however the data need to be extracted from the pivot table. I am sick of doing copy/paste so many times. Is there any solution to automate the process by using any of the MS-office application. Any suggestion/help will be appreciated as it will really save lot of my time. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot table cutting information of a part of the information | Excel Discussion (Misc queries) | |||
how do i refresh a pivot table report in a shared file | Excel Discussion (Misc queries) | |||
"A pivot table report cannot overlap another pivot table report" | Excel Worksheet Functions | |||
Making a pivot table report static. | Excel Discussion (Misc queries) | |||
A pivot table report cannot overlap another pivot table report. | Excel Discussion (Misc queries) |