Shane
04-08-2008, 10:43 PM
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
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