Macros VBA question: copy paste from Pivot to a table in another sheet

[excelnewbie765]

Hi, I wonder how to create VBA macros that are able to copy-paste values from a Pivot row to a table in another sheet. Be mindful that his pivot has several rows and I need to copy the values from each row to different tables in another sheet. This is a repetitive task that I need to do on weekly basis.. so I would like to automate it as much as possible. Thank you for the answer!

 

[sijpie]

Yes, not a big problem.

The data set, which is what you have in the upper part of the image can be addressed in VBA with the pivottable.databodyrange

You can then loop through each row of this range and place it in the various sheets on the right date row.

In order to provide some working code, I will need to know which sheet is to be used for each row of the data set.