1. D

    TableDestination: Pivot Table Macro

    Hey guys, I'm new to the forum but over the past week found a lot of useful data that has lead me to my first problem I am unable to resolve using other's posts. I've created a pivot table that is placed on an existing worksheet using a dynamic named table for the range. I've been able to...
  2. S

    Pivot table in new Worksheet

    My VB code makes a new worksheet for every PT (or rather will in the near future). I'm trying to get that to work, but I ran into some problems with TableDestination. ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _ "'Data'!" &...

Some videos you may like

This Week's Hot Topics