Thread: re-using pivot table layout
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
TomPl TomPl is offline
external usenet poster
  
Posts: 342
Default re-using pivot table layout
Clear the contents of the old month's data.

Paste the new data where the old data was.

Right click within the pivot table and select "Refresh Data".

Happy days, you are done!

Tom
Reply With QuoteReply With Quote