New work sheet in Pivot with auto name

[FAHMED]

DEAR CHANDOO


VERY NICE TO SEE UR SITE AND UPDATE


I AM FACING A PROBLEM WHAT I HAVE TO DO FREQUENTLY IN PIVOT TABLE


Below is sample pivot table.

Sum of Qty

Flower Total

Rose 615

Grand Total 615


When double clicking 615 (in Total column) there will generate a new worksheet naming sheet2.

I want new work sheet name will be according to name of row level header like “Flower”.

Like when I will double click quanty 615, I need produced worksheet name will be “Flower”

Is there anyone to solve it through vb.

 

[vijaySharma]

FAhmed,


Welcome to Chandorg Forums...


Have a look at the below link


http://blog.contextures.com/archives/2011/06/10/delete-excel-drilldown-sheets-automatically/


~VijaySharma