Create separate excel workbook with name of Tabs & mail to multiple concern person

[devyadav2008]

Dear All,

I have to create separate workbook with name of tabs name and mail to concern person

Like in a master sheet i have some sheet with name of A,B,c and so on.........

I have to create separate sheet with name of A, B,C and so on and mail sheet A on A's mail id, mail sheet B on B's mail id and so on ...

Please help in automation

[#2]

@devyadav2008 

To be clear, you have a master sheet with a list of groups "A", "B", "C", etc.  You're looking to produce a sheet with records for "A", a sheet with records for "B", etc.

You can accomplish this quickly with a pivot table.

1. Pivot your data

2. Add the "Groups" field to both the Row and the Values.

3.  Double click the number next to "A" to show data and produce a worksheet with those records.

4.  Repeat for the other groups

5. Enjoy

More details here:

https://support.office.com/en-us/article/Expand-collapse-or-show-details-in-a-PivotTable-or-PivotCha...