Hi All, I'm trying to automate a report which shows 3 pivot tables and on chart on a worksheet. My pivot tables work fine but, they all want to over-write each other. My 1st pivot is placed at: Set PT = ActiveSheet.PivotTables.Add(PivotCache:=PTCache, TableDestination:=Range("B1"), TableName:=("Achieved Missions"))
The second Pivot is placed at: Set PT = ActiveSheet.PivotTables.Add( _
PivotCache:=PTCache, _
TableDestination:=Range("B12"), TableName:=("Planned Missions")) I really wanted the pivot to be placed at two rows beneath the next blank row. Is there away around this or do I have to plave each pivot on a separate sheet?
The second Pivot is placed at: Set PT = ActiveSheet.PivotTables.Add( _
PivotCache:=PTCache, _
TableDestination:=Range("B12"), TableName:=("Planned Missions")) I really wanted the pivot to be placed at two rows beneath the next blank row. Is there away around this or do I have to plave each pivot on a separate sheet?