Creating Multiple Pivots through VBA Code

Hi,

Attached is my excel data and I need to create multiple pivots on one sheet. I have Created the pivots that i require as my desired output alongwith a recorded macro.
Can you please help me with the code or rectify the recorded code that would create a pivot for different data and ranges.

Instead of requiring your macro to go to a specific sheet and a dedicated pivot try using;

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

and then use generic markers for the rest? I don't have time (or skill?) to fix anything now but hopefully this will help.

Thanks. I will try to work on that.