Pivot table using VBA

Hi- I am trying to use VBA to export the data into sheet3 as a pivot table. However, when I recorded the macro I noticed the amount of rows that have the data are being add in there. However, this data changed every week so the amount of rows are not going to be the same. Is there a way to use a code that select whatever data is in sheet2 to export to sheet3 as a pivot table?
Capture.JPG

Thank you.

This is all you need

Please Login or Register  to view this content.