Need VBA help to split the master data > new workbook>pivot

[vinu]

Hello Team,

I have scenario need your vba expertise to build this.

Sumamry :

The input data file need to be split by coulumns and create pivot table and details in a seperate sheet for each paring of the column data and save it in a folder.

Details

Input file : enclosed the copy, would like to split the data based on the country[india , china and so on] and type[AP, GL only] (column O and M)

and created the sample pivot for reference.

output : should create based on country files. in this case 2 files india and china

each country will have the AP and GL data.

1. India : will have 4 tabs :

- AP : AP summary pivot
- AP details - pivot details (from the input data) - which contains all the columns
-GL : GL summary pivot
-GL detaisl : pivot details (from the input data) - which contains all the columns


same way for china as well.

I have more than 20 countries to be done in the same way. attached input file and the out put file for india country.

can you please help....

Regards
Vin

 

[Hui]

Have you read these posts?

Move Data to other Sheets
http://chandoo.org/wp/2012/05/14/vba-move-data-from-one-sheet-to-multiple-sheets/

Advanced Filter Move Data to other Files
http://chandoo.org/wp/2011/10/19/split-excel-file-into-many/

 

[vinu]

Thanks Hui - I can use this and modify.