PDA

View Full Version : Copy data from Pivot Table



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

Shane
04-09-2008, 02:07 AM
Someone Pls help ...


Regards,
Shane

rory
04-09-2008, 05:43 AM
I'm not sure what you want - can't you just double-click the Grand Total (where the 9 is) in your table?