Use Pivot item name to be new worksheet's name

[novodisc]

Hi,

When we double click on an item from a pivot table, a new sheet will be created.

I would like to use the item name in the pivot table to be the new worksheet's name when i double on that item.

Is there a way to do this?

Please see attached file for more info.

Thanks.

[Andy Pope]

Right click Pivot sheet tab and click View Code. Paste following

Please Login or Register  to view this content.

In Thisworkbook object paste the following

Please Login or Register  to view this content.

In a standard code module paste the following

Please Login or Register  to view this content.

Currently the code does not deal with duplicate sheet names.

[novodisc]

Thanks a lot for your help.

[novodisc]

Right click Pivot sheet tab and click View Code. Paste following

Please Login or Register  to view this content.

In Thisworkbook object paste the following

Please Login or Register  to view this content.

In a standard code module paste the following

Please Login or Register  to view this content.

Currently the code does not deal with duplicate sheet names.

Hi Andy,

I did not get it to work correctly...
Can u pls help? I have attached a copy of the example with the codes.. Pls let me know where i am going wrong... thanks a million...

[Andy Pope]

I just double clicked in B5 and it created a new sheet called Apples.

What exactly does not work for you?

[novodisc]

I just double clicked in B5 and it created a new sheet called Apples.

What exactly does not work for you?

I think i know why it is not working... i have another pivot table in another tab. Can the script be amended so that it can work with more than 1 pivot table in the workbook?

[Andy Pope]

Please don't quote previous responses unless relevant, it just clutters the thread.

remove that code and paste this in the Thisworkbook object. It will work for the first pivot table on any sheet.

Please Login or Register  to view this content.

[novodisc]

Thanks for your help Andy