VBA Code to replicate Pivot table data and apply a % to a value field

Hi,

In the attachment i have a piviot table of data, what i need to do is replicate all entries from a sheet called "Original Morca" for each Row Label in the pivot (the amount of rows will change month on month).

Following the replication i then need to apply the sum of the value in column K by the 5 next to each row label in column L (in the pivot table sheet) and bring all these entries together in 1 sheet.

Can anyone help on this at all?

I have the following code to copy the entries over but i'm not sure on how i can continue this for each row on the pivot table?

Please Login or Register  to view this content.