My pivot table shows in rows, differerent locations and in columns, the month of the year from April to March
This is populated from an imported CSV.
Any new sites visted are added onto the bottom and the amount of visits per site in each month are summarised. As the data is confidential I have attached a generic sheet showing what I mean.
I have several pivot tables on different worksheets and am looking for a way to automatically select the data and copy is to a specified area on another worksheet in the same book after the pivot is 'refreshed' with the new data.
Clearly I can just select, copy and paste the values but I'm looking for a way to 'automate' the process.
Apologies if this is in the wrong forum. Not sure if it came under Pivot Tables, VBA, or something else. Please feel free to place in correct forum.
Many thanks
Moderator's note: Moved from Excel General--6StringJazzer
Bookmarks