• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How can pivot table data be divided into multiple worksheets

K

KiKi

Member
I need to divide the PT data into multiple worksheets. I used the option report filter pages, but on every worksheet, the entire PT shows with specific filter. However i want to distribute data in multiple worksheets/excel so that one sheet contains data specific for one filter. so that i can email individual sheets to everyone, and everybody is seeing data concerned to them.
 
Asheesh said:
Can u share a sample workbook and the required result.
Click to expand...
Sure. I hope this will help.

Please find attached file. Every worksheet here shows filtered data, but selecting the other filter in same worksheet also provides me data which i want to hide from a particular student tab.

I have attached the updated file where desired result for Bret in a last tab.. same i want for every other one. Thanks
 

Attachments

  • Multiple worksheets.xlsx
    24.9 KB · Views: 7
Last edited:
I got attached code and sample file for that macro which goes per my requirement. However, existing code doesn't create worksheets on it own, however i have 1000 of students, so i want to create as many worksheets by the code as there are students. As i am new to VB so really not sure which part to change. I also got the code to create worksheets, however not sure how to insert it in original file. Any help would be helpful
 

Attachments

  • Code to copy raw data into multiple worksheets.txt
    1.2 KB · Views: 1
  • move-data-from-one-sheet-to-many-example (1).xlsm
    23.9 KB · Views: 1
  • code to add worksheets.txt
    570 bytes · Views: 0
I might have a crack at coding something up to do this. Kiki: the code could also prompt you for a list containing the email addresses, and automatically email each of those 1000 individual worksheets to the relevant student, meaning you don't have to do anything but click one button and it's all done.
 
Kiki...would your real pivottable happen to have a field containing student email addresses in it? Or are those email addresses in a separate table?

Also, where is the source data for the PivotTable? Is it an Excel range, or is the PivotTable connected to a database?
 
jeffreyweir said:
Kiki...would your real pivottable happen to have a field containing student email addresses in it? Or are those email addresses in a separate table?

Also, where is the source data for the PivotTable? Is it an Excel range, or is the PivotTable connected to a database?
Click to expand...

Email address is in the seperate table and source data in pivot table which in turn connected with database which is manually refreshed every month.
 
jeffreyweir said:
I might have a crack at coding something up to do this. Kiki: the code could also prompt you for a list containing the email addresses, and automatically email each of those 1000 individual worksheets to the relevant student, meaning you don't have to do anything but click one button and it's all done.
Click to expand...

How can it be done?
 
With lots of code. I'm taking a look at it, and have made quite a bit of progress. I'm going to release a commercial add-in that does this.
 
You must log in or register to reply here.
Back
Top