Automatically create files from database

[neeraj_chow]

I summarise my data (more than 5000 records) which is compiled daily from different sources using a pivot table, comprising of more than 20 unique items.
On a daily basis, I have to break the database into 20 files (i.e. the number of unique items in a particular field in the file) and circulate the file to different persons
I was looking for a way wherein I could automatically segregate the database into 20 different files with the filename and sheet names be having the name of the unique item plus the number of records in the file in brackets.
Help will be greatly appreciated.

 

[BrianB]

If I get you right, you want to show the base data of the 20 fields ?

If so, doubleclicking the PT total cell will produce a sheet with the data.
This principle can be used in a macro by recording the action.