So I am trying to create a macro that pulls all values from a pivot table and moves them to a new spreadsheet.
In the above example, I want to pull all dates and the values associated with them without pulling the headers. Does anyone know how I would go about that? I was thinking about creating an array of all subheader titles but can't think of a good way to take that array (I already have it made) and use it to efficiently pull all other values