Copy data from Pivot Table

[Shane]

Hi,

I usually got data in the form of Pivot Table from users. Later I have to manually pick values from pivot table and paste in another sheet basis some criteria to display in proper format.

I want to create a macro that helps me to pick data from pivot table and transfer it to proper format. Criteria would be basis service type, BU and TAT. Sample output format is available in sheet2.

Please help.

Regards,
Shane

[Shane]

Someone Pls help ...


Regards,
Shane

[rory]

I'm not sure what you want - can't you just double-click the Grand Total (where the 9 is) in your table?