Excel

[Devender Kumar Yadav]

First i have created multiple sheets based on one column data with the help of report filter in pivot (Like Person Name)

after this i create a copy of all tabs separately and attached in personalized mail to concerned person.

So please share if any solution for time saving.

 

[Devender Kumar Yadav]

Please find attached sheet

 

[Marc L]

You must amend your thread title according to the forum rules ‼​

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

 

[p45cal]

Two things you might do to save time:
1. Make a pivot table like this, especially note Name in the Filters area:


Then you can:


choose Name in the next dialogue that pops up, and as many new sheets will be added as there are Names. each with its own pivot table.

Or:
2. Make a pivot table like this:

with subtotals for the Name field. If you double-click on each subtotal, a new sheet will be created with a table comprising only the rows of the source data that make up the subtotal values.
If you have a lot of names, you can collapse the Name field so that your subtotals are all next to each other: