Copying Data from Pivot and pasting it to specific location

Hi All,

I am working on a report and need some help in order to automate some stuff. Id someone can help me with VBA code to copy specific data from pivot.
I am attaching the sample file. I want to copy years, months and data of each stage in specific sheets.
For example I have filled tab 'Stage 1' manually and in same way I want this data to be copied whenever run the code

Any help will be appriciated

Thanks
Dinesh

Do you really required a macro!!!

Another option..
Place Subcategory at Page FILTER section.
Go to Analyze > Pivot Table > Show PivotReport Filter Pages and in the next screen select "SubCategory"

ExcelForum#1051309.jpg

Without viewing your already developed code.. here is a less bullet-prrof idea.. check the attached..

Please Login or Register  to view this content.

ExcelForum#1051309.xlsm

Hi Dinesh,

does this help?

Sample2 - Decar.xlsm

As a little tip for posting dummy data. Check the Data Source of the Pivot, it still shows the path of the original file on your computer which includes the Name of the company this data is from.


*Edit: Just realised Debraj already posted a solution. Thanks for that, I did not know you could do it like this. Way more efficient than how I did it.