VB 6.0 - How to merge three pivot table Data into one pivot table

Asked By Salma banu on 14-Aug-09 05:48 AM

I am creating a reporting structure for managers where i have to provide report to each manager giving the details of the manger function and location and the Direct_repotess name,function working under him and the rollup reportess working under him.

So I created three pivot tables now i want to merge all this three tables data into one table. And create separarate workboook for each manager.


PFA the excel file with the pivot tables

Thanks,

Salma


How to merge three pivot table Data into one pivot table - Salma banu replied to Salma banu on 14-Aug-09 05:55 AM

You would have to work with Macros for such things. - [)ia6l0 iii replied to Salma banu on 14-Aug-09 10:31 AM

If you need workbooks per manager, i.e. 40 managers in your case, there is no automated way. 

This would be the macro logic. 

You would have to pull each manager's name and create a distinct workbook. 
And then do a vlookup for each manager's direct and reporting data
And then create a pivot table for this data in the new workbook.
And then save. 

This has to be iterated in a memory loop for all the managers