neeraj_chow
Board Regular
- Joined
- Aug 1, 2003
- Messages
- 62
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.
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.